Active Query Builder

Customizable SQL Query Building Environment

Simple and clear presentation of database structure and user queries

  • Restricting access to database objects, preventing query execution

    You might want to deny access to certain fields and tables to meet the safety requirements or get rid of a user of needless parts of your database structure. Using the Active Query Builder, you can do this easily. Building a query via a visual interface, you can hide undesirable objects and fields of your database.

    The ability to retrieve various information about the query, such as list of used tables and fields, allows you to prevent the execution of unauthorized queries.

  • Designing a user-friendly query building environment

    Active Query Builder allows you to substitute unintelligible names of database objects and fields for user-friendly aliases ("alternate names"). Among changing the names of real objects, you can add your own virtual objects and fields. Acting as derived tables ("virtual objects") and sub-queries or expressions ("virtual fields"), they look like ordinary objects and fields to the end-user. All aliased object names that were used in the query will be substituted back for real names, sub-queries and expressions automatically in the resultant SQL query text.

    While building SQL queries with aliased object names visually, the end-users can still edit them by hand. Active Query Builder generates two versions of a query: for the end-user and for database server and it's able to parse both.

  • Changing metadata representation the way you like

    By means of the component, you can transform the database schema the way you need for its better understanding by the end-user. You can add descriptions for objects and fields, re-arrange objects within the Database Schema Tree according to the subject area, or by some other characteristics. You can add custom nodes to the Database Schema Tree to store frequently used objects or saved user queries.


Related articles of the Knowledge Book:
Detailed information about Active Query Builder:

News

Testimonial

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. Please keep up the good work.

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

Active Query Builderon Google+