Active Query Builder  »  SQL Query Builder

Safe and user-friendly SQL Query Building Environment

Simple and clear presentation of database structure and user queries

  • Restricting access to database objects, preventing unwanted query execution

    Active Query Builder lets deny access to certain fields and tables to meet the safety requirements or get rid of a user of unwanted parts of your database schema. You can hide specific objects and fields of your database schema from the user's view and deny the generation of queries containing hidden objects. The ability to retrieve various information about the query, such as lists of used tables and fields, allows preventing the execution of unauthorised queries.

  • Designing 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"). Among changing the names of real objects, you can add your virtual objects and fields. Such objects look like ordinary objects and fields to the end-user; in fact, they represent complex SQL expressions, regular or correlated sub-queries.

    Visually building a query, 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 again 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 the database server and parse them both.

  • Changing presentation of your database schema

    Through 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 favourite or frequently used objects.

  • User repository of reusable queries

    One of the most exciting features of Active Query Builder is the ability to save queries in the repository and re-use them in further queries as regular database views. Having a frequently used query in the repository, the user can drag it to 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 allows for keeping user queries simple and increase productivity by re-using frequently used datasets.


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

News

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks