SQLeoVQB

SQLeo is a free open source SQL Query builder front end that permits to create or display complex sql queries easily as Access (Microsoft query) do and permits to reverse engineer database models as db designers do.

This GUI supports virtually all JDBC drivers, including ODBC bridge, has been tested with Oracle, MySQL, Firebird, HSQLDB, Postgresql, 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, brio quey ...


Features

Connexion 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 (hidde) or unpack unused columns from a table
- save query as image, .xlq or .sql
- reverse SQL syntax to graph (not finished Yet)
Content/Preview:
- grid display with data filtering, sorting
- rowcount
- jump to parent or child table data
- insert, update, delete data in grid
- export data, import data (text or csv)
Command Editor (should be reserved for DDL or DML usage)
+
new 2012.01: store joins definition in a local csv file
new 2012.07: content / preview window fetch only first rows
new 2013.02: Reverse subqueries improvments
new 2013.04: Filter icon in graph for predicates
new 2013.05: auto arrange Entities in graph using spring force model
and many bug fix