Active Query Builder  »  SQL Query Builder

Graphical Query Builder

Visual SQL query building has never been easier

  • Intuitive drag & drop visual query building interface

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

  • Adding tables, linking them by drag & drop

    The user can quickly find the needed tables to by browsing the Database Schema Tree or typing the object name in the search text box. He can drag the necessary tables on the Design Pane and then check the needed fields there, or he can browse the object fields right in the object tree and drag the required fields to the Query Columns Grid of graphical query builder.

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

  • Specifying complex SQL expressions, grouping, sorting and criteria

    The Query Columns Grid allows reviewing all information about the query result data at a time. Each field and SQL expression used in the query is listed there. You can specify complex SQL expressions with functions and sub-queries via the inline cell editor or use the custom expression editor.

    The same grid lets specify output column names, define sort order, aggregates, 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. Visual query builder warns users about duplicate query column names and other inconsistencies that may arise during the query building process.

  • Visual building of queries with unions and sub-queries

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


Related articles of the Knowledge Book:
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