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

Our team has worked with the Active Query Builder components since the middle of 2014.

By using Active Query Builder we have managed to upgrade our applications to the point where we can enable users with very little to no knowledge of SQL to access their databases and retrieve accurate summaries of their data. The component itself is flexible, easy to use, user friendly and consistently improved upon. Any issues that might occur are dealt with by a support team that sets the benchmark for customer service and professionalism.

In short, a superb product developed and supported by a superb team.”

Gert Venter, IDSC


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!

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