Active Query Builder for .NET 3.3 lets work with reusable queries in an easy way.
Reusable queries can be used as views in further queries. They will be automatically expanded to derived tables for execution against the database server.
Active Query Builder ASP.NET Edition 2.13 lets add calculated fields by end-users.
Users can hide SQL expressions behind the fields to not worry about their complexity while building a query.
Active Query Builder for .NET 3.2.1 eliminates roughnesses of the previous minor version and makes the UI smoother.
Working with Common Table Expressions (CTE) has been made easier.
Active Query Builder for .NET 3.2 improves the user experience with the new docked side panels.
The user can define DISTINCT, LIMIT, and TOP clauses in no time. Managing queries with UNION set operators has been simplified.
Active Query Builder ASP.NET Edition 2.12 automatically restores the component's state after session expiration.
Diagnostic messages about server configuration errors and incorrect communication with the server have been made clearer.
Active Query Builder for .NET (WinForms and WPF) 3.1 is released.
This is the final release. WinForms DevExpress controls UI is added, flat view mode for Database Schema Tree is made, lots of bugs are fixed.
How do you use the Alternate Names feature?
A feature that was primarily made to display clear names for database objects can be helpful in other cases.
Active Query Builder ASP.NET Edition 2.11 introduces redesigned sub-query navigation bar.
User experience is improved and the look is much better now.
The new purchase options and the new beta version of Active Query Builder WinForms and WPF editions are available
The sub-query navigation bar is updated, migration and quick start guides are published.
Active Query Builder 3: new major version for WinForms and WPF is out. Download and try now!
The first beta version of WinForms and WPF editions introduces the new component's architecture and the new sub-query navigation bar.
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.