Query Builder

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 multiple Unioned statements.
  • support for the WITH statement
  • build complex Where clauses.
Building an advanced column list with the Query Builder

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

Many Useful Helpers

The Query Builder has many little 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
  • has a dialog for building a Case expression
Building a Case expression