The new long-awaited major version of Active Query Builder 2.0 is released for public beta testing now. It is available in the Customer's area for the customers of Standard and Professional .NET Subscriptions who have their subscription in active state.
Important note: There are many breaking changes in this release and for now it can not be installed together with the old version, so you'll have to install the new and old versions in turn. A better way is to use a virtual machine for testing.
What's new in Active Query Builder 2.0?
More detailed description of the new features will be given in the Knowledge Book soon. The Load Metadata and the Metadata Structure demo projects illustrate some aspects of the new functionality.» All Active Query Builder news
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, 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.