Active Query Builder is a query builder component suite for Borland Delphi / C++ Builder that allows your end-users to build SQL queries via a visual interface. It features an SQL parser that handles SQL queries containing multiple nested joins and other fine points of SQL syntax. Another feature is the graphical engine that allows you to build queries involving unions, nested joins and sub-queries.
Active Query Builder supports the vendor's Accuracer and EasyTable components, as well as MS SQL Server, Oracle, MySQL, PostgreSQL, Interbase/Firebird, SQLite, and ANSI-92 SQL dialects. The Active SQL parser can translate any valid SQL statement into its visual representation. You can use a range of database connectivity components as well as a generic event-driven metadata provider to get metadata information from any data source.
The interface of Active Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface.