Active Query Builder
»
SQL Query Builder
Safe and user-friendly SQL Query Building Environment
Simple and clear presentation of database structure and user queries
- Restrict access to database objects and prevent unwanted query execution
Active Query Builder lets you deny access to certain fields and tables to meet safety requirements, or block a user from restricted parts of your database schema. You can hide specific objects and fields of your database schema from users, and restrict queries containing hidden objects. The ability to retrieve various information about a query, such as lists of used tables and fields, allows you to prevent the execution of unauthorized queries.
- Design a user-friendly query building environment
Active Query Builder allows you to replace unreadable names of database objects and fields with user-friendly aliases ("alternate names"). Besides 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 can represent complex SQL expressions, regular or correlated subqueries.
When building a query visually, users can work with aliased database objects, virtual objects and fields with no difference, as if they were real objects in your database. They can even see the "result" query text with the objects, make changes to it, and get back to visual query building. All aliased object names will be substituted again for the real names, subqueries 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 the database server - and parse them both.
- Change the presentation of your database schema
With Active Query Builder, you can transform the database schema so it's clearer to the end users. 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 subject area or some other attribute. You can also add custom nodes to the Database Schema Tree to display favorite or frequently used objects.
- Leverage the repository of reusable queries
One of the most exciting features of Active Query Builder is the ability to save queries in the repository and reuse them in further queries as regular database views. With a frequently used query in the repository, the user can drag it to the design area while building a new query so that it will appear in it as a database object. When the user needs to execute such query, Active Query Builder will expand such objects into derived tables or CTE.
Reusable Queries let users keep their queries simple and increase productivity by reusing frequently used datasets.
Related articles in the Knowledge Base:
Detailed information about Active Query Builder: