View Image

SQLeo is a free open source SQL Query builder based on SQLeonardo.2009.03.rc1 (used in Jasper Reports and Pentaho), that permits to create complex sql queries easily as Access (Microsoft query) do. This GUI supports virtually all JDBC drivers, including ODBC bridge, has been mainly tested with Oracle, Mysql, Firebird, HSQLDB, CsvJdbc ...

The main added feature to SQLeonardo (after bug fixing) is the ability to store all the joins definition in a local csv file, to generate SQL even when the database has no FK implemented or for views.

Can be compared with : FreeQueryBuilder (SQLeonardo ancestor), SQuirreL SQL, Active Query Builder, Flyspeed, Oracle SQLdeveloper, Toad, DbVisualizer ... or command line utilities like: SQLTools++, PKlite, ...

FEATURES:

· Connection setup and Metadata explorer
· Query Builder
· create joins with drag and drop, foreign keys or with csv definition
· supports all types of join: inner, rigth-left-full outer, natural
· supports group by, order by, subqueries, union ...
· pack (hide) or unpack unused columns from a table
· save query as image, .xlq or .sql
· grid display with data filtering, sorting
· jump to parent or child table data
· insert, update, delete data in grid
· export data, import data (text or csv)
· Command Editor, show object definition
· Reverse SQL syntax to graph (not stable Yet)
· new: resizable windows
· new: explicit commit-rollback in addition to autocommit
· in progress: store all the joins definition in a local csv file