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. Active Query Builder automatically adds links between tables and allows for browsing of linked objects to add to the query.
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 mode enables independent editing of sub-query text and sub-query results preview.
Users can explore the relationships between objects right on the Design pane and quickly add them to the query, but they don't have to do this. Using Active Query Builder users can add only the needed tables to the Design pane: the necessary joins and intermediate objects will be added automatically. You can even turn off the Design pane and let the users add fields to the query by drag & drop.
Active Query Builder lets you switch between visual query building and direct SQL text editing with no hassle: the user always sees the resulting SQL query text while building a query visually; he/she can change the query text and get back to the visual query builder, which will parse the modified SQL text and reflect changes on the query diagram. This lets novice users to learn SQL while building the queries visually and provides the experienced query writers with an excellent SQL query visualization tool for better understanding of their structure.
Active Query Builder cares for keeping the user query text unchanged. None of conditions and options will be lost after the parsing and re-building of the query.
Using the Active Query Builder's SQL query text formatter you can beautify the SQL code the way you need. There are many options to customize the SQL query text layout, such as line breaks, indentations and word wrapping. Advanced formatting options allow for the setting up of dynamic indentation by the first item in the list.
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.