Active Query Builder  »  Blog

April 28, 2018

Much faster visual and programming SQL query building in the new major version!

Dear friends,

Today we announce the main improvements in the new major version that will help users and developers be more productive than before. The upcoming release of Active Query Builder for .NET will be available until the end of this year.

Core improvements

The main core change is the new serializable query object model. It will store every single SELECT statement the way you see it in the query text: lists for the SELECT, GROUP BY, and ORDER BY clauses and tree-like structures for the WHERE and HAVING clauses. This model will significantly ease the programmatic SQL query analysis and modification.

Besides, we have made the new fluent API to build SQL queries the way close to the SQL language.

Three main advantages of the new API:

• It is type safe and uses the pre-generated objects from your database schema, so you get compilation errors when table or field is missing or misused.
• You get SQL text for any database server supported by Active Query Builder from the single query definition.
• It is easy to read and easy to write queries with it using the IDE auto-completion: lists of SQL functions, database objects and their fields are always at hand.



Visual improvements

The tree-like interface to edit conditions in the WHERE and HAVING clauses will be available in all versions.

You can let users define conditions in the old way, so users can gradually move on to using the new interface, as soon as they realise its advantages.

Only four columns in the Query Columns Grid will be necessary to build a query: SQL expression, Column name, Sorting and Grouping/Aggregate.



Further improvements

For the rest of the year, we aim to provide a more compact and clear view of SQL queries and database schema for end-users.

Objects on the design pane match real-world objects

Complex real-world entities are represented in a relational database by several tables. Assembling them in a single object on the design pane will give a more clear view of the database schema.

Hiding intermediate objects

Hiding objects which are only used to define many-to-many relationships from the Design Pane will simplify the query diagram.

Trivial actions must be trivial

Users will be able to define conditions, grouping and sorting right from the Design pane.

We hope these improvements will meet your expectations for a convenient query building interface. Please feel free to submit your feedback.

Author: Sergey Smagin at ActiveDBSoft.

» All Active Query Builder news

Comments by Disqus: