SQLeonardo, SQL graphical query builder

Hello, here are modifications proposal:

- Resizable windows
"query builder", "command editor", "metadata explorer" should be resizable like data "preview" windows

- Object / column filter
shema / object type /object name / column name filters used in "metadata explorer"
should be reused for window "query builder"

- Query content window should fetch only first rows (and not all as done today),
or all if scrolling to the end of page asked
check that column "sort ascending/descending" still works
check that export isn't broken
number of lines to be defined as a global parameter

- SQL Query graph drawing fk to pk link shoudn't redraw other pk to fk (when many)
exemple can be given
put a flag in parameters for this mode ?

- SQL commander should permit non-autocommit mode (with explicit commit/rollback)
put a flag in header "autocommit on/off" ?

- local joins model ... (the biggest part)

creating a copy of table all_constraints and all_cons_columns
and populating them with the non implemented FKs works fine
(I can provide corresponding SQL for Oracle)

to be evaluated later
storing informations in table(s) with a structure like:
relation name,
relation type (inner join, rigth-left-full outer join ...)
table,
table alias (not mandatory),
field and field position
referenced table,
referenced table alias (not mandatory),
referenced field and ref field position,
comment (not mandatory)...

see for functions in relations to be taken into account
Init, usage and updates to be defined

jre version: to be defined
favorite rdbms oracle

Regards

you can email me at hotmail.com