Release Notes: This release introduces an interceptor layer for adapting and monitoring any query or update to your data. It greatly improves JDBC insert performance by using batch inserts instead of regular statements. It sanitizes the type conversion API to use the new interceptor layer.
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.