Active Query Builder is a Delphi VCL component that simplifies SQL query creation. With its user-friendly interface and unique research capabilities, this two-way builder is suitable for both novice and seasoned query writers.
Active Query Builder is an outstanding two-way visual query builder component designed for Delphi and C++ Builder software platforms. This exceptional tool provides users with the opportunity to create complex SQL queries using a convenient visual interface that resembles MS-Access. Notably, Active Query Builder is more potent than other similar components in the market. It presents an intuitive and straightforward approach to defining sorting and grouping criteria.
Additionally, this software allows for the visualization of each union and sub-query in its independent working area. The SQL dialects supported by Active Query Builder include Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, Informix, Sybase, SQLite, among others. The software's sophisticated SQL parser completes the visual representation of any valid SQL statement with full Unicode support. The SQL Formatter feature allows users to adjust the SQL code layout according to their preferences.
Active Query Builder gives the user total control of their SQL query, as they can navigate it using the software's internal query builder objects. Users can also modify existing SQL queries and create new ones programmatically. Working with parameters, it is easy to determine their names, data types, as well as the database objects and fields they are related to.
Furthermore, the software allows users to deny access to selected fields and tables to meet security requirements. Users also have the option of removing irrelevant parts of their database structure. Active Query Builder presents an easy and straightforward way of building queries via a visual interface, thus making it possible to hide undesirable objects and fields of a database.
Users can retrieve a wealth of information about their queries using Active Query Builder, such as lists of tables and fields used in the query. This feature significantly reduces the possibility of unauthorized queries when appropriately utilized. The latest version of Active Query Builder allows users to replace table and field names with user-friendly aliases.
Furthermore, the software is compatible with DevExpress controls and Unicode-enabled TnT library. Overall, Active Query Builder is a must-have tool for building flexible and robust SQL queries in a visual environment.
Additionally, this software allows for the visualization of each union and sub-query in its independent working area. The SQL dialects supported by Active Query Builder include Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, Informix, Sybase, SQLite, among others. The software's sophisticated SQL parser completes the visual representation of any valid SQL statement with full Unicode support. The SQL Formatter feature allows users to adjust the SQL code layout according to their preferences.
Active Query Builder gives the user total control of their SQL query, as they can navigate it using the software's internal query builder objects. Users can also modify existing SQL queries and create new ones programmatically. Working with parameters, it is easy to determine their names, data types, as well as the database objects and fields they are related to.
Furthermore, the software allows users to deny access to selected fields and tables to meet security requirements. Users also have the option of removing irrelevant parts of their database structure. Active Query Builder presents an easy and straightforward way of building queries via a visual interface, thus making it possible to hide undesirable objects and fields of a database.
Users can retrieve a wealth of information about their queries using Active Query Builder, such as lists of tables and fields used in the query. This feature significantly reduces the possibility of unauthorized queries when appropriately utilized. The latest version of Active Query Builder allows users to replace table and field names with user-friendly aliases.
Furthermore, the software is compatible with DevExpress controls and Unicode-enabled TnT library. Overall, Active Query Builder is a must-have tool for building flexible and robust SQL queries in a visual environment.
What's New
Version 1.13:
- Firebird 2.5 support is added.
- Embarcadero RAD Studio 2010 is supported now.