| Completely visual building of complex SQL queries |
| Visual building of sub-queries |
yes |
yes |
yes |
yes |
| Visual building of unions |
yes |
yes | yes |
yes |
| Columns pane allowing to define grouping, sorting, and constructing criteria |
yes |
yes | yes |
yes |
| Tree pane to browse and navigate query tree |
yes |
yes | yes |
yes |
| Visual criteria constructing tool for Where and Having clauses * |
no |
yes! | no |
yes! |
| Support for various SQL Dialects |
| ANSI-92 Standard SQL |
yes |
yes | yes |
yes |
| Accuracer |
no |
yes! |
no |
yes! |
| EasyTable |
no |
yes! |
no |
yes! |
| Oracle |
no |
yes! | no |
yes! |
| Microsoft SQL Server |
no |
yes! | no |
yes! |
| MySQL |
no |
yes! | no |
yes! |
| PostgreSQL |
no |
yes! | no |
yes! |
| InterBase/Firebird |
no |
yes! | no |
yes! |
| SQLite |
no |
yes! | no |
yes! |
| Several visual representation models |
| MS Access style |
yes |
yes | yes |
yes |
| SQL Server Enterprise Manager style |
yes |
yes | yes |
yes |
| Full set of database drivers |
| Accuracer |
no |
yes! |
no |
yes! |
| EasyTable |
no |
yes! |
no |
yes! |
| ADO (ActiveX Data Objects) |
yes |
yes | yes |
yes |
| BDE (Borland Database Engine) |
yes |
yes |
|
|
| dbExpress |
yes |
yes |
|
|
| InterBase Express |
yes |
yes |
|
|
Zeos DBO,
MySQL, PostgreSQL, InterBase/Firebird, MS SQL, Sybase, Oracle, DB2 |
no |
yes! |
|
|
| Allround Automations DAO,
|
no |
yes! |
|
|
| CoreLab Oracle DAC,
|
no |
yes! |
|
|
| CoreLab MySQL DAC,
|
no |
yes! |
|
|
| Generic event-driven metadata provider |
yes |
yes | no |
no |
| Output filters to transform SQL code into the format you need |
| Plain text output filter |
yes |
yes | yes |
yes |
| HTML output filter * |
no |
yes! | no |
yes! |
| RTF output filter * |
no |
yes! | no |
yes! |
