Active Query Builder lets 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. You can hide certain objects and fields of your database schema from the user's view and deny generation of queries containing the hidden objects. The ability to retrieve various information about the query, such as lists of used tables and fields, allows to prevent the execution of unauthorized queries.
Active Query Builder allows you to replace unreadable names of database objects and fields with user-friendly aliases ("alternate names"). Among changing the names of real objects, you can add your own virtual objects and fields. Such objects look like ordinary objects and fields to the end-user, in fact they represent complex SQL expressions, ordinary or correlated sub-queries.
Building SQL queries visually the user will work with aliased database objects, virtual objects and fields without a difference, as if they were real objects in your database. He/she can even see the "result" query text with these objects, make changes to it and get back to visual query building. All aliased object names will be substituted back for real names, sub-queries and expressions in the resultant SQL query text thanks to the ability to generate two versions of a query: one for the end-user and another for database server and parse them both.
By means of Active Query Builder, you can transform the database schema for its better understanding by the end-user. You can add descriptions for objects and fields, group objects within the Database Schema Tree according to physical database schema or re-arrange them according to the subject areas or by some other characteristics. You can add custom nodes to the Database Schema Tree to display favorite or frequently used objects.
One of the most exciting features of Active Query Builder is the ability to save queries in the special repository and re-use them in further queries as ordinary database views. Having a frequently used query in the repository, the user can drag it to design area while building a new query, so it will appear in it as ordinary database object. When user needs to execute such query, Active Query Builder will expand such objects into derived tables or CTE.
Reusable Queries allows for keeping user queries simple and increase productivity by re-using frequently used datasets.
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.