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.
In the process of building a query it is often not known what data the user will get as a result. Therefore it is more convenient to modify the query at the stage of browsing its results. But going back to the visual query builder means to distract from the data analysis. So we took another step towards the user, and created a visual component that allows you to set filters visually in convenient tree-like form. CriteriaBuilder utilizes API of the non-visual QueryTransformer component that allows for adding filters, changing sorting and limits and applying aggregations (to get totals).
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.