Active SQL Query Builder is a visual query builder component suite that allows your end-users to build complex SQL queries via an intuitive visual interface.
Completely visual building of complex SQL queries.
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.
MS-Access style and SQL Server style visual query building interface.
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.
User-friendly interface with drag & drop support.
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.
Sophisticated SQL parser translating any valid SQL statement into its visual representation.
Generated from the improved CoCo/R Compiler Generator, Active SQL Parser correctly handles multiple nested joins and other fine points found in some SQL dialects.
Delicate handling of user queries.
We care about keeping user queries in the same form as they entered in the SQL query builder. None of conditions and options will be lost after query parsing because we understand how important they are to the user.
Oracle, SQL Server, MySQL, and lots of other SQL dialects support.
- Microsoft SQL Server
Active SQL Query Builder supports various Transact SQL extensions, such as the TOP clause that limits the number of rows, table and join hints used by the query optimizer, the COMPUTE BY clause to generate summary.
- SQL Server 2005 support: the WITH clause to specify a temporary named result set (CTE), new types of query combinations (UNION, EXCEPT and INTERSECT).
Active SQL Query Builder supports expressions with dollar-quoted strings, user defined data types, standard and user defined operators. For example:
Select OrderId is not Null, true or false, 1+ |/2+2
Where OrderName~~'qwe%' or '123'~'^1'
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.
- DB2, Informix, Sybase and even more dialects will be implemented next month.
Text, RTF* and HTML* export filters.
Using the Active SQL Query Builder output filters you can transform SQL code into the format you need, customized the way you like it. There are a lot of properties that can be used to customize the resulting SQL query representation, specifying when to move to the next line, to increase the indent, to wrap a line.
* - forecast
Active Query Builder is a special component.
It wasn't created for some internal needs, it was made to meet customer needs. This is a component that 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 your complete visual solution for SQL query building!
Buy now Active Query Builder!