Active Query Builder
makes work with SQL queries EASY!

Active Query Builder is the best choice when...

  • Your users need data, but itís hidden in the interior of your relational database,
  • You want to give the end-user a bright idea how he can find the right data and get it with ease,
  • You need means for programmatic analysis and creation of SQL queries.

Active Query Builder is a visual SQL query builder, SQL parser, and professional SQL text editor.

Active Query Builder is an ad-hoc SQL query builder component for different development environments: WinForms and WPF .NET, ASP.NET, Java, and Delphi/C++Builder.

Free versions for non-commercial use and trial versions for commercial use are available for different development environments:
Active Query Builder for WinForms
   » Windows Forms .NET 4.0+ component
Download free trial now
Active Query Builder for WPF
   » WPF .NET 4.0+ component
Download free trial now
Active Query Builder for ASP.NET
   » ASP.NET MVC (Razor, ASPX) component
Download free trial now
Active Query Builder for Java
   » Swing-based Java bean component
Download free trial now
Active Query Builder for Delphi
   » Delphi and C++ Builder component
Download free trial now

Visual Query Builder

Active Query Builder lets design most complex SQL queries with unions and sub-queries visually by drag'n'drop. Visual query builder represents each single sub-query on a separate tab. It allows to browse the structure of sub-queries in a tree-like form.

SQL Query Builder

Active Query Builder is a true two-way SQL query builder. It allows for combining visual query building with direct SQL text editing. The user can switch between SQL query builder and text editor at any time. Changes made in the SQL query text will be reflected in the query building UI.

Data retrieval assistant

Active Query Builder isn't just an SQL query builder. It helps to organize the query execution and data browsing in your application. It provides full information about the query parameters and helps to fill their values. The easy-to-use SQL filter builder, ability to change sorting, add aggregates and apply pagination to your queries helps to create professional data browsing environment for end-users.

SQL Parser and Analyzer

Active Query Builder's SQL parser is capable to parse any arbitrary query designed for vast majority of popular database servers. The complete information about database objects and fields used in the query is instantly available after SQL query parsing. Active Query Builder lets analyze SQL queries to deny execution of unwanted queries, ability to change SQL queries programmatically allows for preventing unauthorized access to data.

Active Query Builder is all you need to work with SQL queries!




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