Active Query Builder  »  SQL Query Builder

SQL Query Parser

Programmatic SQL Query parsing, analysis and modification

• Powerful means of SQL query parsing and analysis

  With Active Query Builder, you can easily parse SQL queries, and analyze and modify queries at the level of internal query structure object model or SQL token syntax tree. You can edit existing queries or create new SQL queries from scratch. For example, you can analyze a complex query with subqueries for the presence of specific tables, and add conditions for them to each subquery in which one of these tables is present.

• Quick access to general information about a query

  You don't need to delve into the internal query object model to learn what database objects and fields were used in a query. Detailed information about used database objects and fields is available for the whole query as well as for every part of the query: a subquery, data source or output expression is instantly available through the QueryStatistics set of collections. You can get lists of used database objects, fields and output expressions for the query.

• Full information about query parameters

  Active Query Builder supports various types of parameters: prefixed with a semicolon (":param") or "commercial at" symbol ("@[My Param]"), or represented by a single question mark ("?"). You can get a list of query parameters via the Parameters collection. There you can get parameter names and data types, and discover the database objects and fields to which they relate.

• Quick Start Guides
• Working with parameters
• Retrieving common information about the query
• Understanding complex SQL query structure representation
• How to change sorting, add filters, limits and aggregations to the query?

• Simple and clear visual SQL query building interface
• Customizable SQL query building environment
• Metadata handling and filtration