If you are viewing this file on CRAN, please check the latest news on GitHub where the formatting is also better.

dbi.table v1.0.7

NOTES

1. Fixed a bug (Issue #6) where x[y] did not return the reference result when x contains a WHERE clause.

2. Evaluation of special functions (e.g., %in%) now RDBMS specific.

dbi.table v1.0.6

NOTES

1. Added support for lists of the form .(name = symbol) to the on arguement in the extract ([) method. Thanks to @SugarRayLua for reporting the issue.

dbi.table v1.0.5

NOTES

1. Bug fix. as_cte was putting the CTEs in the wrong order when the input already included a CTE. This caused DuckDB >= 1.4.0 to bork.

dbi.table v1.0.4

NOTES

1. 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.

2. 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.

3. The column naming scheme for relational merge (i.e., merge(x)) has been changed.

dbi.table v1.0.3

NOTES

1. dbi.tables in schemas are now implemented as active bindings so that data.table’s setcolorder does not change their column order.

2. 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.

dbi.table v1.0.1 (10 December 2024)

1. Initial CRAN release.