What's new in this release:

Added limit and offset support.
Added information_schema support.
Improved COUNT performance on large queries.
The execution planer is now stateless with cache in parser.
Added standard aggregate functions and GROUP BY support.
Now is possible to change catalogs (needs to be enabled in properties).
Added support to functions in SELECT and WHERE expressions.
Added TRUE and FALSE literals to SQL values.
Fixed function metadata.
Added a connection parameter for timezones. Improved date and time conversions.
Added standard SQL92 functions.
Added IN clause.
Fixed blob methods (loading, searching and encryption).
Added support to ORDER BY clause.
Added support for parameters in PreparedStatement. Now is possible to cancel a statement.
Added a planner compiler for performance improvement.
Added DISTINCT support in SQL statements.
Added support do SELECT without FROM.
Fixed SQL State code and SQL Exception types.
Added a possibility to use fixed values in SELECT clause.
Added comment support.
Added ResultSet fetch direction support. Added a better type conversion.
Added left, right and cross join support.
Added table join support.
Review all database and table metadata and fixed various memory and performances issues.
Rewrite the code for all BLOB and CLOB types.
Added schema support in SQL and queries.
Added BCD file type support.
Added Graph, OLE and Formatted Memo types.
Added encrypted file support.
Fixed the charset support.

Full Changelog: v1.5.0...v1.6.0

Provide feedback