Active Query Builder

A foolproof assistant in your work with SQL queries.


Let users write SQL queries faster and smarter

Working with Active Query Builder your end-users...

  • get the clear view of your database schema,
  • write the well-formed standardised SQL queries conforming the schema,
  • understand the meaning and purpose of even complex SQL queries.

It gives novice users the possibility to practice SQL safely and helps professional query writers to be productive, allowing to see data during the query building process, reuse queries and expressions.

With Active Query Builder you...

  • decrease the number of support requests,
  • save time of high-qualified stuff to write queries for users,
  • save money on teaching users SQL,
  • make users adherent to your software.

Take away the pain of inadvisable SQL queries

Active Query Builder helps build correct joins and queries with grouping avoiding common pitfalls, review relationships between objects and warn about errors in SQL expressions.

It helps find answers to questions like "what does this query do?", "what's wrong with my query?", "why my query does not work?"

Take control of user queries

With Active Query Builder you know everything about user queries. Learn which data users query, what parameters they use, how they join objects and what conditions they apply, and act:

  • deny execute of unwanted queries,
  • modify user queries to limit access to data,
  • suggest better ways to write specific queries.

Active Query Builder includes:

  • Visual SQL Query Designer,
  • Visual SQL Filter Builder, and
  • Professional SQL Text Editor.

Active Query Builder has state-of-the-art API to build SQL queries programmatically, powerful SQL Parser which 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


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