Active Query Builder

Active Query Builder News

November 25, 2016

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.

October 27, 2016

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 for .NET 3.2 improves the user experience with the new docked side panels.
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.

News

Tweets

Testimonial

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.

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