With Active Query Builder you can easily parse SQL queries, analyze and modify queries at the level of internal query structure object model or at the level of SQL token syntax tree. You can edit the existing queries or create new SQL queries from scratch. For example, you can analyze a complex query with sub-queries for presence of specific tables and add conditions for them to each sub-query in which one of these tables present.
You don't need to examine to internal query object model to see what database objects and fields were used in the query. The detailed information about used database objects and fields is available for the whole query as well as for every part of the query: a sub-query, a data source or an output expression is instantly available through the QueryStatistics set of collections. You can get lists of used database objects, fields and output expressions of the query.
Active Query Builder supports various types of parameters: prefixed with semicolon (":param"), commercial at symbol ("@[My Param]") or represented by a single question mark ("?"). You can get a list of the parameters that were used in the query via the Parameters collection. Using it you can determine their names and data types, and discover to what database objects and fields they are related.
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.