Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Subqueries are located on separate tabs and can be accessed and built visually as easy as the main query.
Unions are managed from within the union panel at the corner of the visual builder pane. You can build a query containing several unions in a few clicks!
The Active Query Builder columns pane allows you to define grouping, sorting, and constructing criteria in a simple and direct way.