Active Query Builder  »  Blog


January 16, 2018

Our plans for Active Query Builder

Hello,

Many lesser improvements from version to version make it difficult to assess the development direction. The need to change the project source code makes moving to a new major version not so attractive. Thus, many users still use old versions of Active Query Builder. In our blog, we tried to summarize the changes that were made in the component compared to the previous major version.

Definitely, we understand the weaknesses of our product, and we want to make it better, just like thirteen years ago, when we started work on Active Query Builder.

Our main goal is not just to replace the text editor with a graphical interface (although it deserves our close attention) but to give the user an opportunity to think about the data he needs to get with the query, not about the nuances of the SQL language.

So, we have huge plans for the current year.

  • First, we want to get rid of the current Query Columns Grid and replace it with the new control which will combine the tree-like criteria builder, the query result data grid and the query results preview.
  • Next, we will let undo any change made by the end-user in the user interface.
  • Also, we are preparing some API and core improvements which will simplify the design of SQL queries for developers.

Stay with us for this year and you'll be able to surprise your end-users and let them be more productive than before!

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