Active Query Builder

Active Query Builder News
October 06, 2017

Active Query Builder VCL Edition 1.28 introduces new SQL formatting options.
Formatting of IF and CASE clauses, descriptions in hints of the Metadata Tree, editing parameters of stored procedures and other improvements have been made.

October 03, 2017

Active Query Builder ASP.NET Edition 2.14 improves its JavaScript API.
Initialization in MVC projects has been changed, new demo projects have been added.

July 21, 2017

Active Query Builder Professional VCL Subscription is available now.
It additionally includes the Advanced SQL Text Editor, SQL Expression Editor and the SQL Filter Builder controls.

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.

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