One of our users notified us about interesting results he had got. He tested the component and found out that the parser speed is much lower in version 0.9.9 as compared to 0.9.8. But he hasn't noticed that the amount of memory needed to parse the query reduced from tens of megabytes to a hundred of kilobytes! The point is that we implemented garbage collection during the parsing process. It made parsing slightly slower but significantly reduced the amount of memory needed.
By the way, having optimized the parser for version 1.0, we managed to achieve both good-enough speed and low memory spend.
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.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.
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.