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.
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, ...
TE Connection setup and Metadata explorer
TE Query Builder
TE create joins with drag and drop, foreign keys or with csv definition
TE supports all types of join: inner, rigth-left-full outer, natural
TE supports group by, order by, subqueries, union ...
TE pack (hide) or unpack unused columns from a table
TE save query as image, .xlq or .sql
TE grid display with data filtering, sorting
TE jump to parent or child table data
TE insert, update, delete data in grid
TE export data, import data (text or csv)
TE Command Editor, show object definition
TE Reverse SQL syntax to graph (not stable Yet)
TE new: resizable windows
TE new: explicit commit-rollback in addition to autocommit
TE in progress: store all the joins definition in a local csv file
SQLeoVQB 2013.02 RC 2 Server software developed by legrand_legrand. The license of this server software is freeware, the price is free, you can free download and get a fully functional freeware version of SQLeoVQB. Do not use illegal warez version, crack, serial numbers, registration codes, pirate key for this server freeware SQLeoVQB. Always use genuine version that is released by original publisher legrand_legrand.