Active Query Builder  »  SQL Query Builder

Graphical Query Builder

Visual SQL query building has never been easier

  • Enjoy the intuitive drag & drop visual query building interface

    The graphical query builder interface will look familiar for MS Access users, but it's more convenient and feature-rich. It gives you a straightforward way to build and modify SQL queries of any complexity by dragging tables from the database schema tree, choose query output columns, and define groupings, sorting, and criteria. DISTINCT, TOP, LIMIT and other advanced/database server-specific clauses can be set visually.

  • Add tables and link them with drag & drop

    You can quickly find the needed tables by browsing the Database Schema Tree or typing the object name in the search text box. Then you can drag the tables to the Design Pane and check the needed fields there, or browse the object fields right in the object tree and drag the required fields to the Query Columns Grid in the graphical query builder.

    After dragging an object from the Database Schema Tree to the query, the necessary joins with already existing objects are created automatically with foreign keys. You can explore the relationships between objects right on the Design pane and quickly add referenced objects to the query.

  • Specify complex SQL expressions, grouping, sorting and criteria

    The Query Columns Grid allows you to review all the information about the query result data at a glance. Each field and SQL expression used in the query is listed there. You can specify complex SQL expressions with functions and subqueries via the inline cell editor or use the custom expression editor.

    The same grid lets you specify output column names, define sort order, aggregates, and grouping, and apply filters to the result data set. Active Query Builder always keeps the query in the valid state when building a query with grouping: any non-aggregated output column is automatically included in the GROUP BY clause. The visual query builder warns you about duplicate query column names and other inconsistencies that may arise during the query building process.

  • Build queries visually with unions and subqueries

    Each union query and subquery has its own design area, so you can build it visually, just as smoothly as a single query; you can get access to each union and subquery in one click using the tree-like query structure browser. Support of Common Table Expressions and derived tables is provided in accordance with the rules of specific SQL syntax.
    Editing subquery text and previewing subquery results preview make easy to understand every single subquery in a complex query.


Related articles in the Knowledge Base:
Detailed information about Active Query Builder:

News

Testimonials

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