Active Query Builder  »  Blog


January 12, 2018

Faster, smarter SQL query builder

We are getting a question from our customers: what do we get on upgrading Active Query Builder to the third version?

Honestly saying, almost nothing. But your end-users will get a lot! :)

Most of the core and API improvements have been delayed to the next major version. The component's user interface has been significantly changed to improve the user experience.

In this article, we tried to sum up more than four years of the component development.

  • User interface customizations

    • The visual interface now consists of separate controls. You can combine them the way you like.
    • Dockable panels help to keep essential controls at your fingertips without clogging the UI.
  • Usability

    • Buttons next to fields involved in foreign key relationships let add linked objects in a single click.
    • The new properties bar allows setting the query, link and datasource properties in a handy way.
    • The new Sub-query Navigation Bar lets work with UNION sub-queries and Common Table Expression (sub-queries in the WITH clause) conveniently.
    • Search and filtration in fields of datasources on the Design pane helps quickly find the needed field.
    • Reusable queries panel allows for organising user queries and using them in other queries just like ordinary database views.
  • Care

    • New tips help users keep away from usual problems in their queries.
    • Smart notifications about erroneous SQL expressions the user typed let quickly switch to the place where error origins and correct the mistake.
  • Speed

    • Speeded-up database schema tree loads thousands of objects almost instantly.
    • Optimized metadata loading process.

If you have thoughts about what we can do better in Active Query Builder, please share them in the comments to this article.

at ActiveDBSoft.
» All Active Query Builder news

Comments by Disqus:

News

Tweets

Screenshots

Join Types

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 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.


Active Query Builder Screenshots

Social networks