Active Query Builder

SQL Query Builder which makes getting data easy!


Active Query Builder is the best when...

  • Your users need data but it's hidden in the inside of your database,
  • You want to give a clear view of your database schema for your users,
  • You need API to analyse and create SQL queries.

Active Query Builder is a component for different development environments: WinForms and WPF, ASP.NET, Java, ActiveX, and Delphi / C++Builder.

Active Query Builder includes a Visual SQL Query Designer, SQL Query Parser, and Professional SQL Text Editor. It supports dozens of SQL dialects.


Free versions for non-commercial use and trial versions for commercial use are available for different development environments:

   » Windows Forms .NET 4.0+ component
Download free trial now

   » WPF .NET 4.0+ component
Download free trial now

   » ASP.NET (WebForms, MVC, Core) component
Download free trial now

   » Swing-based Java bean component
Download free trial now

   » 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.”

Rating: 5 out of 5


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