The SQL builder is a built-in tool of DTM SQL editor. It is the step-by-step constructor that helps users to create SQL statements.
It is suitable for: SELECT, INSERT, UPDATE, DELETE statements. Also, it supports CREATE and DROP for most popular objects: TABLE, VIEW, PROCEDURE, TRIGGER, and INDEX.
Limited support for GRANT and REVOKE statements is also available.
How the builder can save your time?
You should not enter keywords manually - just select required clause.
You have not to remember exact object (like table or column name), the tool allows you to select it from the list.
You should not remember exact statement syntax - the builder constructs it from clauses automatically.
It adds schema (or owner) prefix to table or view automatically.
You have not to quote values manually. The builder do that automatically depends on column's data type.
It supports three modes: append, replace and insert - you are allowed to combine results of a few builder executions.
The SQL builder is also suitable for new SQL users. The tool shows currently created statement after each step: it is good visual learning tool for novices.
How to use SQL Library for most frequently used statements and queries.
Does the software suitable for PostgreSQL users and programmers?