Active Query Builder  »  SQL Query Builder

SQL Text Editing and Formatting

Two-way SQL query builder and SQL Text Editor

  • Two-way SQL query building (visual query building combined with SQL text editing)

    Active Query Builder lets you switch between the visual query building and direct SQL text editing with no hassle. The user always sees the result SQL while designing a query; he/she can change the query text and get back to the visual query builder at any time. The component will parse the text and reflect changes on the diagram. Such flexibility lets novice users learn SQL while building the queries visually and provides the experienced query writers with an excellent SQL query visualisation tool for better understanding of their structure.

    Active Query Builder cares for keeping the user query text unchanged. All the clauses and syntax-specific options will remain the same after the query parsing and generation.

  • SQL query text formatting/beautifying.

    Using the Active Query Builder's SQL query text formatting tool you can beautify the SQL code the way you need. There are many options to customise the SQL query text layout, such as the case of SQL keywords, line breaks, indents and wrapping by words. Advanced formatting options allow for the setting up of dynamic indentation by the first item in the list.

  • Independent SQL sub-query text editing

    Complicated SQL queries with multiple sub-queries are hard to edit. Active Query Builder not only helps to understand complex SQL query structure but also allows for getting and setting the sub-query text so that the user can edit the text of sub-query and apply it back to the query. The user works with the current sub-query as if it was a separate query. When the user gets back to the main query, he sees the entire query text.

    Ability to get the text of the currently active sub-query in conjunction with the Query Transformer API that allows applying limits to the query (top n records) enables the sub-query result preview.

  • SQL Text Editor with code completion and syntax highlighting

    The Professional .NET Subscription additionally 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.

Related articles of the Knowledge Book:
Detailed information about Active Query Builder:



We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks