The interface of graphical query builder will look familiar for MS Access users, but it's more convenient and feature-rich. It allows you to build and modify SQL queries of any complexity by dragging tables from the database schema tree, choose query output columns, define grouping, sorting and criteria in a simple and direct way. DISTICT, TOP, LIMIT and other advanced/database server-specific clauses can be set visually.
User can quickly find the needed tables to by browsing the Database Shema Tree or typing the object name in the search text box. He can drag the needed tables on the Design Pane and then check the needed fields there, or he can browse the object fields right in the object tree and drag the needed fields to the Query Columns Grid of graphical query builder.
On dragging object from the Database Schema Tree to the query the necessary joins with already existing objects are created automatically according to the foreign keys. Users can explore the relationships between objects right on the Design pane and quickly add referenced objects to the query.
The Query Columns Grid allows to review all information about the query result data at a time. Each field and SQL expression used in the query is listed there. You can specify complex SQL expressions with functions and sub-queries via the inline cell editor or using the custom expression editor.
The same grid lets specify output column names, define sort order, aggregates, grouping and apply filters to result data set. Active Query Builder always keeps the query in valid state when building a query with grouping: any non-aggregated output column is automatically included in the GROUP BY clause. Visual query builder warns users about duplicate query column names and other inconsistences that may arose during the query building process.
Each union and sub-query has own design area to build it visually as easy as a single query; you can get access to each union and sub-query in one-touch using the tree-like query structure browser. Common Table Expressions and derived tables are supported in accordance to specific SQL syntax rules.
The special visual query builder mode enables independent editing of sub-query text and sub-query results preview.
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.