If you are viewing this file on CRAN, please check the latest news on GitHub where the formatting is also better.
RDBMS-specific functions are now generic and existing code has been moved to methods. Methods are provided for RMariaDB, RPostgres, RSQLite, duckdb, and Microsoft SQL Server. The default methods rely on DBI alone and should provide basic functionality where DBI is fully implemented.
data.table-style keys are partially implemented. A
key can be specified when creating a dbi.table.
dbi.tables created by dbi.catalog (and
dbi.attach) use the table’s primary key as the
default.
The column naming scheme for relational merge (i.e.,
merge(x)) has been changed.
dbi.tables in schemas are now implemented as active
bindings so that data.table’s setcolorder does
not change their column order.
In reference.test, when the output of
all.equal is not TRUE and
verbose = TRUE, the format of the message now
matches print(all.equal(...)). Thanks to @MichaelChirico for
the report and fix.