The interface of Active SQL Query Builder is similar to MS-Access, but much more powerful compared to other similar components. It allows you to define grouping and sorting, and construct criteria in a simple and direct way. The advanced query properties, such as DISTICT, TOP, LIMIT, etc., might be set visually as well.
Each union and sub-query has its own working area where it can be built visually as easy as a single query; you can get access to each union and sub-query in one-touch with the query structure tree. Common Table Expressions are supported as well.
The special mode enables the editing of sub-queries independently from the main query.
Active Query Builder lets you switch between visual query building and direct SQL text editing with no hassle: in building a query visually the user always sees the resulting SQL query text; he/she can change it at any time and get back to the query builder, which will parse the modified SQL text and reflect changes instantly. This allows novice users to learn SQL while building queries visually and provides the experienced query writers with an excellent tool to visualize SQL queries for a better understanding of their structure.
We care about keeping user queries the same as they were entered in the SQL query text. None of conditions and options will be lost after the parsing of the query because we understand how important they could be as a result.
Using the Active Query Builder's SQL query text formatter you can beautify the SQL code the way you like it. 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.
Active Query Builder provides additional control for composing of criteria that allows to filter the resultset data in convenient way.
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.