Active Query Builder

Visual SQL Query Builder component

Active Query Builder allows your end-users to build complex SQL queries as well as to parse, analyze SQL queries, and represent them visually. Its powerful API allows you to parse complex SQL queries for programmatic analysis and modification. Active Query Builder is a true two-way query builder and, therefore, the end-user can combine visual query building with direct SQL query text editing.

Active Query Builder is a complete solution to make the SQL query building process in your application as easy as it can be!

Key advantages of Acitve Query Builder

• Simple and clear visual SQL query building interface

  Active Query Builder renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with SQL queries. The interface of Active Query Builder is similar to MS Access and SQL Server’s visual query building interface. Therefore, it is already familiar to most database users.

• Customizable query building environment

  Active Query Builder provides unique opportunities to customize the presentation of database schema for the end-user. You can tune everything: add descriptions and change database object names, remove unwanted objects and add virtual objects and fields, group objects by subject area, etc. Having changed all of this, you will receive correct SQL queries to your database without any effort as a result.

• Easy metadata management

  Active Query Builder can load metadata automatically from direct DB connections as well as programmatically from various custom datasources, such as web services and .NET datasets. Filtration by database, schema and object name, manual removing of unwanted objects is possible. Once loaded, metadata can be saved to XML to build queries disconnected from the database in multi-tier or web environment.

• Powerful programming API

  Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries as well as analyze and modify them programmatically via the internal query builder objects. The detailed information about used database objects and fields is available for every part of the query. By using this information you can deny the execution of unwanted objects or add the necessary conditions to the query in order to prevent unauthorized access to the data.

• Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, DB2, Informix, Sybase, SQLite, Teradata dialects and standard ANSI SQL/92, 89 and 2003 SQL syntax.

  By claiming the full support of these SQL dialects, we mean the possibility of the parsing of almost any valid SQL query for the given database server and keeping of every single query clause during the query modification process without any losses. Active Query Builder SQL Parser correctly handles multiple nested joins and other fine points of various SQL dialects.

• Integration with your application by adding a few lines of code

  The component can be integrated into your application with just a few lines of code. The Knowledge Book, documentation and numerous demo projects included in the installation package allows for mastering the component for just a few days.