Release Notes: A significant new release, containing support for MongoDB databases (both read and write) and XPath/SAX-based reading of XML files as tables. It contains a few bugfixes.
Release Notes: This release adds a module for querying and updating Salesforce.com installations, backed by the Salesforce.com Web services. It adds a module for querying SugarCRM installations, backed by SugarCRM Web services. It optimizes support for DB2 queries with firstRow and maxRows properties set, yielding a ROW_NUMBER query in the background database interaction.
Release Notes: Many query parser improvements, including parsing column names with dots, mixed case clause declarations, select DISTINCT queries, select item aliases, and selecting everything from multiple from items. It also fixes two bugs: an issue with interpreting CHAR types as strings, and inclusion of function names (if available) in TableModel header names.
Release Notes: This release fixes timestamp literals on DB2's SQL-dialect.
Release Notes: This release drastically improves the performance of "DELETE FROM" statements on CSV files. It adds mapping of unavailable-to-available data types when issuing "CREATE TABLE" statements containing unavailable data types on e.g. DB2 or PostgreSQL. It fixes a bug pertaining to multi-threaded execution of compiled JDBC queries. A pool of prepared statements has been created to ensure parallel execution of compiled queries. A bug has been fixed pertaining to proper quoting of HAVING clause operands when the data type of the aggregate function is different from the data type of the functions argument.
Release Notes: Queries can now be compiled, preparing them for execution with varying parameter values. For JDBC databases, this will provide prepared statement-like functionality. For other datastores, it will simply make query reuse simpler. DataSet index caching has been implemented, making lookup by column or by "select item" faster and constant-time.