- Building complex SQL queries visually with ease.
The interface of Active SQL Query Builder is similar to MS-Access, but much more powerful compared to other similar components. It allows you to define grouping and sorting, construct criteria in a simple and direct way. Each union and sub-query has its own working area where it could be built visually as easy as single query; you can get access to each union and subquery in one-touch with the query structure tree. The advanced query properties, such as DISTICT, TOP, LIMIT, etc., might be set visually as well.
- Designing user-friendly query building environment
Active Query Builder allows you to substitute unintelligible names of database objects and fields for user-friendly aliases ("alternate names"). Among changing names of real objects, you may define your own virtual objects (views) and fields. Acting as derived tables ("virtual objects") and sub-queries or expressions ("virtual fields"), they look like an ordinary objects and fields to the end-users. 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. Acitve Query Builder generates two versions of a query: for the end-user and for database server, and it's able to parse both.
Having database without foreign keys, you may add them to the component's metadata repository so tables will be joined automatically when added to a query.
- Formatting SQL query text layout.
Using the Active Query Builder's SQL Formatter you can customize SQL code layout the way you like it. There are a lot of properties that can be used to customize SQL query output, such as line breaks, indents and word wrapping.
We care about keeping user queries in the same form as they were entered in the SQL query text. None of conditions and options will be lost after parsing of the query because we understand how important they could be in result.
- Powerful means of SQL query parsing and analysis.
Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries and navigate them using the internal query builder objects and modify SQL queries programmatically.
Working with parameters in Active Query Builder, you may know their names and data types, and discover to what database objects and fields they are related to.
- Restricting access to database objects, preventing query execution
You might want to deny access to certain fields and tables to meet the safety requirements or get rid a user of needless parts of your database structure. Using the Active Query Builder, you can do it easily. Building a query via a visual interface, you can hide undesirable objects and fields of your database.
Ability to retrieve various information about the query, such as list of used tables and fields, allows you to prevent execution of unauthorized queries.
- Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQLite and ANSI SQL/92, 89 and 2003 dialects SQL syntax.
By claiming full support of these SQL dialects, we mean the possibility of parsing of almost any valid SQL query for the given database server and keeping of every single query clause during the query modification process without any losses. Generated from the improved CoCo/R Compiler Generator, Active SQL Parser with full Unicode support correctly handles multiple nested joins and other fine points found in some SQL dialects.
Using Active Query Builder you can determine the currently used database server automatically, in case it cannot be defined in advance.
- Working in offline mode, storing metadata in XML files.
In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offline mode, loading metadata information from a previously saved XML file. It also makes loading metadata almost instant regardless of the number of objects being loaded.
- Localization.
Now it is possible to localize Active Query Builder completely and to switch between available languages in run-time.
- Active Query Builder is a special component.
It wasn't created for some internal needs, it was made to meet customer needs. This component was made by a team of enthusiast programmers to express their vision of the visual query building. All your comments and suggestions will be taken into consideration because we really want to make it the best tool possible.
Active Query Builder is complete solution for visual SQL query building!
- Learn more about specific editions of Active SQL Query Buider:
