Active Query Builder

Active Query Builder News

April 28, 2017

Active Query Builder VCL and ActiveX Editions 1.27 are released.
Support for RAD Studio 10.2 Tokyo has been added, links creation has been improved, Query Transformer is now capable of renaming output query columns.

February 27, 2017

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.

January 21, 2017

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.

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.

News

Tweets

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