The Query Builder allows you to build complex queries easily:
build queries and join tables using an intuitive graphical interface
table relationships can be picked up automatically from the database
join information can be saved as a "user-defined relationship", and used in later joins
AQT can reverse-engineer a query - eg. it can parse query SQL and display it in the graphical format. This makes it easy to visualise and amend queries (not just those built by AQT). Very few tools on the market have this capability.
As you develop the query, the generated SQL is shown in the bottom part of the window.
AQT's Query Builder
Feature-rich Query Builder
The Query Builder supports a number of advanced query syntax constructs:
joins can be innner or outer (left/right/full). Join expressions and join functions are supported. Join syntax can be native or ANSI-standard.
support for table expressions / inline views. These can be developed in a separate linked Query Builder window.
support for table and column correlation names.
ability to specify column functions.
support for summary (GROUP BY) queries.
support for multiple Unioned statements.
support for the WITH statement
build complex Where clauses.
Building an advanced column list with the Query Builder
Reverse Engineer Queries
The Query Builder can parse an existing query and display it in the Query Builder:
the SQL can be any valid SQL, whether built by AQT or by some other product
can deal with most query syntaxes which the Query Builder supports - this includes joins, table expression, unions, WITH statements
few tools on the market have this capability
Reverse Engineering of Queries
Where-Clause Builder
The Query Builder has a window for building Where clauses:
helps you easily build a Where clause
column values can be retrieved by clicking on Get Values
the Where clause is displayed in the bottom pane as you build it
easily deals with queries which have hundreds of Where clauses
Building a Where clause with the Query Builder
Union Queries
The Query Builder can build Union queries consisting of multiple Select statements:
each statement in the query is built individually
click on Next or Prev to move through the statements in the query
can specify the join clause (Union, Union All, Intersect, Except) plus bracketting
AQT will check that your statements return the same number of columns and have consistent data types
in the SQL pane at the bottom you can display either your statement SQL or the full SQL
A Union query in the Query Builder
Visual Where
The Query Builder can display a visual representatrion of your Where statement. This makes it easier to understand a complex Where statement.
Visual Where shown in the Query Builder
Many Useful Helpers
The Query Builder has many dialogs for helping build parts of a query:
has an IN List Builder to easily build or modify a large list of IN values
has a dialog for building a SubSelect clause, including a correlated subquery
