SQL Query Builder component

Visual Query Designer, SQL parser and data retrieval assistant

Visual component for WinForms .NET, WPF, ASP.NET, Delphi/C++Builder, ActiveX and Java

Active Query Builder is an SQL Query Builder component to design SQL queries via the intuitive visual interface. It can build queries with sub-queries and unions, allows for previewing the sub-query result data to let users explore the data and debug complex queries.

Active Query Builder gives the end-users clear view of their queries and database schema. It lets think of the needed data, not about the query. It is an ultimate helper for everyday 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.”

Rating: 5 out of 5

Key advantages of Active Query Builder

  • Simple and clear visual SQL query building interface

    The interface of Active Query Builder is familiar to most database users. Users build queries mostly by mouse clicks. They add objects to the diagram by dragging them from the tree, select the needed fields and set their properties.

    Active Query Builder helps users to build SQL queries by giving them advice on object references, keeping away from common errors and warning them about problems. Working with Active Query Builder the user thinks about the data he/she needs to get, not about the SQL syntax correctness.

    Visual query builder lets design queries with sub-queries on separate tabs, edit their texts separately from the main query and preview the sub-query results.

    » Learn more: Visual SQL Query Building

  • Friendly SQL query building environment

    Active Query Builder gives a clear view of your database schema to end-users. It helps users find the needed objects and fields, browse relationships between objects.

    Active Query Builder lets give friendly names for objects and fields. It allows for grouping objects by subject area, defining favourites. With Active Query Builder you can replace real objects with their improved versions, add calculated fields, and hide unwanted ones.

    » Learn more: Customization of the database schema view

  • Reverse engineering of even most complex SQL queries

    Active Query Builder can parse SQL queries of any complexity and build its visual diagram. The ability to parse SQL queries allows for their visual browsing, understanding the structure and analysis.

    Users can preview the result of sub-query execution to get the idea of what data it returns. They can edit the sub-query text apart from the entire query without the fear of ruining the whole query.

  • Combining Visual Query Building with the text editing

    Active Query Builder is a true two-way query builder; the end-user can switch between the visual query building to the SQL text editing at any time. Changes made to the query text are applied to the visual diagram and vice versa.

    The advanced SQL text editor with code completion and syntax highlighting makes SQL text editing convenient for professional query writers. SQL text formatting lets beautify SQL query text to improve the readability.

    » Learn more: SQL Query Text Editing

  • Essential data browsing assistant, Easy-to-use SQL Filter Builder

    Browsing the result query data users need to change sorting, apply filters, and calculate totals. These are essential features to build a convenient interface to work with data.

    Active Query Builder provides API and the accompanying visual SQL filter builder control to perform these operations on a query. This API also can apply pagination to user queries to build paged data browsing interface.

    » Learn more: SQL Filter Builder and Query Transformation API

  • Flexible metadata management, Fast database schema retrieval

    Active Query Builder can load database schema from various DB connections, and custom data sources. You can define filters for metadata to get rid of unwanted objects, or remove them one by one. You can fill database schema by code in case of working with a custom data source or a web service. The component can work without live database connection loading metadata from the pre-generated XML file allowing for reducing the database server load and fasten the component initialisation.

    » Learn more: Metadata Management and Filtration

  • Powerful API to analyse and edit SQL queries

    Active Query Builder gives you full control over user queries. It lets parse SQL queries and get the information about used database objects and fields. You can perform in-depth SQL query structure analysis, edit user queries or create SQL queries from scratch. By analysing user queries, you deny execution of unwanted queries or add the necessary conditions to prevent unauthorised access to data.

    Active Query Builder gives a list of parameters used in the query along with information about fields of database objects to which they are applied to.

    » Learn more: Analyzing and Changing User SQL Queries

  • Full support of numerous SQL dialects and ANSI SQL standards

    Active Query Builder's SQL Parser supports dozens of SQL dialects: Oracle, MS SQL Server, Azure, MySQL, PostgreSQL, SQLite, MS Access, InterBase, Firebird, DB2, Informix, Sybase, Advantage DB, Netezza, Teradata. It correctly handles fine points for each supported SQL dialect. Working with parsed queries, Active Query Builder keeps every single query clause during the query building process with no losses.

    Being compatible with ANSI SQL/92, SQL/89 and SQL/2003 standards, Active Query Builder works fine with many other ANSI SQL-compatible database servers, such as Vista DB, Nexus, Elevate DB, Redshift, Vertica, Progress, Pervasive, Amazon Aurora, and so on.

  • Easy integration into your application

    You can embed SQL Query Builder into your application with a few lines of code. The Knowledge Base, documentation and numerous demo projects help to get acquainted with the component in a few days.

Get Active Query Builder for your development environment:

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