This release adds support for SQL conditional (CASE) statements, support for CAST statements, full and proper support for subselects and subqueries, projection of expressions (such as arithmetic, string concatenation, etc.), major improvements to aggregation (sum, max, min, etc.) handling, and bugfixes to join handling.