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