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:

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