| |
Support for statement types (Select, Insert, Delete, Update) supported join types (inner, left, right, self)
Meta-information available for inspection: Primary key, nullable, datatype etc.
Generation optionally includes schemanames into the built SQL-statements Uses metainformation for generation. Example: if datatype information is available values automatically are quoted.
ability to visualize DB-stored relationinformation - only for displayed tables as well as for all tables (think of displaying a datamodel) - of course this information has to be provided by the database Supports tablenames with whitespaces
For layouting issues fontsizes of your tables can be specified
No syntax-errors in queries
You see that your queries do what they are intended to do. This especially is an advantage in bigger queries.
Generates readable layouted SQL statements
Easier and faster than writing by hand. Just think of queries having a few joins, criteria, sorting clauses and all the other stuff. |
|