When making the parser we ran into some problems. It had been decided to use CoCo/R, a free open source LL(1) parser/scanner generator as the tool for code generation. Originally CoCo/R was not able to generate the Object Pascal code, so we had to improve it.
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.