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!
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.
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.
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.
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.
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.
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.
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, 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.