Active Query Builder

Active Query Builder News

October 18, 2016

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.

April 29, 2016

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.

April 26, 2016

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.

March 29, 2016

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.

February 01, 2016

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.

December 14, 2015

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.

Active Query Builder 3: new major version for WinForms and WPF is out. Download and try now!
November 25, 2015

Active Query Builder ASP.NET Edition 2.10 introduces the new Database Schema Tree
The new metadata browsing control displaying database schema in a tree-like form is made instead of the old list control with drop-downs and pagination.

September 10, 2015

Active Query Builder VCL and ActiveX Editions 1.26 are released
Support for RAD Studio 10 Seattle is added, Netezza SQL syntax is made.

September 07, 2015

Active Query Builder Java Edition 1.9 is released
Support for IBM Netezza and AdvantageDB SQL syntaxes is added.

September 02, 2015

Active Query Builder WinForms .NET Edition 2.10.3 is released
Criteria Builder gets two-way syncronized with the Query Transformer.




With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved. Please keep up the good work.


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