The unique features of Active SQL Query Builder such as the ability to build queries with unions and subqueries make it the best solution for professional developers. Each union and sub-query has its own working area where it could be built visually as easy a single query. The interface of Active SQL Query Builder for Delphi is similar to either MS-Access or SQL Server visual query construction interface, but is much more powerful compared to other similar components. Active SQL Query Builder allows you to tune all parameters of each single part of a query with the dialog window.
Working with Active SQL Query builder you can access each union and subquery in one-touch; complex queries can be navigated easily with the tree pane. Columns pane allows you to define grouping, sorting, and constructing criteria in a simple and direct way. Active SQL Query Builder supports all MySQL extensions, such as the Limit clause that limits the number of rows, the SELECT INTO OUTFILE/DUMPFILE forms, query options, locking definitions, subqueries for MySQL server version starting from 4.1.