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,
www.sourceforge.net/projects/zeoslib: http://www.sourceforge.net/projects/zeoslib
MySQL, PostgreSQL, InterBase/Firebird, MS SQL, Sybase, Oracle, DB2
no
yes!
Allround Automations DAO,
www.allroundautomations.com/doa.html: http://www.allroundautomations.com/doa.html
no
yes!
CoreLab Oracle DAC,
www.crlab.com/odac: http://www.crlab.com/odac
no
yes!
CoreLab MySQL DAC,
www.crlab.com/mydac: http://www.crlab.com/mydac
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!