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.


Related articles of the Knowledge Book:
Detailed information about Active Query Builder:

News

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks