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 case of SQL keywords, line breaks, indentations and word wrapping. Advanced formatting options allow for the setting up of dynamic indentation by the first item in the list.
Complitated SQL queries with multiple sub-queries are hard to edit. Active Query Builder not only helps to understand complex SQL query structure, but also it lets to work with the text of sub-queries. It allows for getting and setting the sub-query text as if it was a standalone query. The user is able to see the text of each single sub-query, to change it and apply to the main query. This process runs seamlessly for the end-user: it always sees the text of the currently active sub-query and works with it. When the user gets back to the main query, he sees the whole query text.
Ability to get the text of the currently active sub-query in conjunction with the Query Transformer API that allows to apply limits to the query (top n records) lets create the sub-query preview facility in your application..
The Professional .NET Subscription additionaly provides the Advanced SQL text editor and Expression editor with code completion and syntax highlighting. It uses Active Query Builder's parsing engine SQL context to determine the current SQL dialect and display the proper completion lists. This facility is available in Active Query Builder for Windows Forms only.
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.