NEWS

dbi.table 1.0.7 (2026-03-01)

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 1.0.6 (2026-01-11)

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 1.0.5 (2025-09-19)

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 1.0.4 (2025-06-28)

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 1.0.3 (2025-02-04)

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 1.0.1 (2024-12-10)

  1. Initial CRAN release.