Active Query Builder  »  SQL Query Builder

Graphical Query Builder

Visual SQL query building has never been easier

• Enjoy the intuitive drag & drop visual query building interface

  The graphical query builder interface will look familiar for MS Access users, but it's more convenient and feature-rich. It gives you a straightforward way to build and modify SQL queries of any complexity by dragging tables from the database schema tree, choose query output columns, and define groupings, sorting, and criteria. DISTINCT, TOP, LIMIT and other advanced/database server-specific clauses can be set visually.

• Add tables and link them with drag & drop

  You can quickly find the needed tables by browsing the Database Schema Tree or typing the object name in the search text box. Then you can drag the tables to the Design Pane and check the needed fields there, or browse the object fields right in the object tree and drag the required fields to the Query Columns Grid in the graphical query builder.

  After dragging an object from the Database Schema Tree to the query, the necessary joins with already existing objects are created automatically with foreign keys. You can explore the relationships between objects right on the Design pane and quickly add referenced objects to the query.

• Specify complex SQL expressions, grouping, sorting and criteria

  The Query Columns Grid allows you to review all the information about the query result data at a glance. Each field and SQL expression used in the query is listed there. You can specify complex SQL expressions with functions and subqueries via the inline cell editor or use the custom expression editor.

  The same grid lets you specify output column names, define sort order, aggregates, and grouping, and apply filters to the result data set. Active Query Builder always keeps the query in the valid state when building a query with grouping: any non-aggregated output column is automatically included in the GROUP BY clause. The visual query builder warns you about duplicate query column names and other inconsistencies that may arise during the query building process.

• Build queries visually with unions and subqueries

  Each union query and subquery has its own design area, so you can build it visually, just as smoothly as a single query; you can get access to each union and subquery in one click using the tree-like query structure browser. Support of Common Table Expressions and derived tables is provided in accordance with the rules of specific SQL syntax.
  Editing subquery text and previewing subquery results preview make easy to understand every single subquery in a complex query.

• Quick Start Guides
• The result SQL query text retrieval
• Modification of subquery text separately from the whole query

• Customizable SQL query building environment
• Metadata handling and filtration
• Programmatic SQL Query analysis and modification