Active Query Builder

Let users write SQL queries faster and smarter

Working with Active Query Builder your end-users...

• get the clear view of your database schema,
• write the well-formed standardised SQL queries conforming the schema,
• understand the meaning and purpose of even complex SQL queries.

It gives novice users the possibility to practice SQL safely and helps professional query writers to be productive, allowing to see data during the query building process, reuse queries and expressions.

With Active Query Builder you...

• decrease the number of support requests,
• save time of high-qualified stuff to write queries for users,
• save money on teaching users SQL,
• make users adherent to your software.

Take away the pain of inadvisable SQL queries

Active Query Builder helps build correct joins and queries with grouping avoiding common pitfalls, review relationships between objects and warn about errors in SQL expressions.

It helps find answers to questions like "what does this query do?", "what's wrong with my query?", "why my query does not work?"

Take control of user queries

With Active Query Builder you know everything about user queries. Learn which data users query, what parameters they use, how they join objects and what conditions they apply, and act:

• deny execute of unwanted queries,
• modify user queries to limit access to data,
• suggest better ways to write specific queries.

Active Query Builder includes:

• Visual SQL Query Designer,
• Visual SQL Filter Builder, and
• Professional SQL Text Editor.

Active Query Builder has state-of-the-art API to build SQL queries programmatically, powerful SQL Parser which supports dozens of SQL dialects.

• Active Query Builder gives a highly productive environment for the end-users to work with SQL queries: database schema browser, visual query designer to build and analyze SQL queries, SQL text editor, and SQL text formatter.
• Active Query Builder is an essential assistant to work with data: passing values for the query parameters, previewing of sub-query results, applying filters, sorting and grouping to result datasets, computing of totals.
• Active Query Builder has powerful API to work with queries: SQL query parsing and analysis, limit access to tables and fields, or even to specific data records, programmatic correction, and creation of new SQL queries.
• Active Query Builder lets ease understanding of complex database schema for the end-users representing the database schema in a simple way.