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 a full-featured component suite for software developers. It includes:

  • A Visual Query Builder component to design SQL queries via the intuitive visual interface.
  • An SQL Query Parser to build SQL query object model of any given SQL query.
  • An SQL Text Editor with code completion and syntax highlighting.
  • A highly-customizable SQL Query Text Formatter.
  • A powerful SQL Query Builder API to modify existing and create new SQL queries by the code.
  • A set of components to build feature-rich data browsing UI with data filtration, sorting and pagination.
  • A set of helpers to connect to different databases and execute SQL queries against them.

Active Query Builder supports dozens of database servers and various generic SQL standards.

Active Query Builder is ideal for SQL professionals who need to get data for ad-hoc reports or extract data from an external DB which structure is not known beforehand.

Active Query Builder gives the end-users a clear view of their queries and database schema. It lets instantly catch the structure of a given query and start thinking of the result 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 and drag'n'drop operations.

    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 aliases 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 brings to the main query. 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 helps to build a paginated 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 initialization.

    » Learn more: Metadata Management and Filtration

  • Powerful API to analyze 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 analyzing user queries, you deny the 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 (MariaDB), PostgreSQL (Redshift), SQLite, MS Access, InterBase, Firebird, IBM DB2 (incl. AS/400), Informix, SAP IQ, SAP SQL Anywhere, SAP ASE, SAP Hana, SAP Advantage DB, Netezza, Teradata, Pervasive (Actian Zen). 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, Vertica, Progress (OpenEdge), Apache Spark, Amazon Aurora, Amazon Athena, Google Big Query, Cassandra, Impala, 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

News

Social networks