duckdb 1.1.3-1

Features

• With duckdb(environment_scan = TRUE), data frame objects are available as views in duckdb SQL queries (#140, #164).

• Update vendored cpp11 to 0.5.1 (#636).

Bug fixes

• Make ./cleanup script reentrant (@Antonov548, #612, #634).

• Fix installation of extensions (#623).

• Fix rchk and UB errors (#635).

• Avoid loading rlang during startup (#601).

Documentation

• Mention xz requirement in DESCRIPTION.

duckdb 1.1.3

Features

• Update to duckdb v1.1.3, see https://github.com/duckdb/duckdb/releases/tag/v1.1.3 for details.

• New duckdb.materialize_callback option, supersedes get_last_rel() (#589).

• New rel_explain_df() and rel_tostring() (#587).

• Handle empty child values for list constants (#186, @romainfrancois).

Chore

• Undef TRUE and FALSE (#595).

• Remove enable_materialization argument to rel_from_altrep_df() in favor of creating a new data frame when needed (#588).

• Flip argument order for expr_comparison() (#585).

• Keep cleanup files to accommodate different build scenarios (#536).

duckdb 1.1.2

Features

• Update to duckdb v1.1.2, see https://github.com/duckdb/duckdb/releases/tag/v1.1.2 for details.

Features

• Long-running queries can now be canceled immediately with Ctrl + C (terminal) or Escape (RStudio IDE and Workbench) (#514, #515).

• Add col.types argument to duckdb_read_csv() (#445, @eli-daniels).

• Rethrow errors with rlang if installed (#522).

• Improve error message for parsing erros during statement extraction (tidyverse/duckplyr#219, #521).

Bug fixes

• Avoid RStudio IDE crashes when ending session with open objects (#520).

• rfuns extension: %in% works correctly as part of a & conjunction (#528).

Internal

• New interal APIs: rapi_get_last_rel_mat(), rapi_rel_to_altrep(allow_materialization = TRUE), rapi_rel_from_altrep_df(enable_materialization) (#526).

• xz-compress duckdb sources in the tarball (#530).

• rfuns extension: Fix signedness.

v1.1.0

What's Changed

• feat!: Rename tbl_query() to tbl_function(), remove translate_duckdb() by @krlmlr in #211
• feat: New rel_from_sql() by @krlmlr in #212
• ci: Various enhancements towards supporting protected branches and auto-merge by @krlmlr
• feat: n_distinct() supports na.rm = TRUE with a single vector argument again by @lschneiderbauer in #216
• fix: Correctly compute vector length for data frames passed to relational functions by @krlmlr in #379
• feat: Tweak implementation of r_base::sum() by @krlmlr in #385
• feat: Reduce size of binary package for Linux on Posit Package Manager by @krlmlr in #386
• feat: Bump vendored cpp11 to v0.5.0 by @krlmlr in #387

Full Changelog: v1.0.0-2...v1.1.0

v1.0.0-2

• Reduce the package installation size on macOS (#185).

Full Changelog: v1.0.0-1...v1.0.0-2

v1.0.0-1

What's Changed

• Upgrade vendored cpp11 to 0.4.7 to fix compilation with R-devel.
• fix: Support new I() syntax from dbplyr by @krlmlr in #195

Full Changelog: v1.0.0...v1.0.0-1

v1.0.0

What's Changed

• feat: Add dbplyr translations for clock::add_days(), clock::add_years(), clock::get_day(), clock::get_month(), and clock::get_year() by @edward-burn in #153
• feat: New sort argument to rel_order() by @toppyy in #168
• feat: round() duckdb translation uses ROUND_EVEN() instead of ROUND() by @lschneiderbauer in #157
• chore: n_distinct() followup by @lschneiderbauer in #158
• feat: Add dbplyr translations for clock::date_count_between() by @edward-burn in #166
• fix: Correct usage of win_current_group() instead of win_current_order() in SQL translation by @lschneiderbauer in #175
• fix: Avoid triggering re2 in tests by @krlmlr in #176
• feat: Support fetching MAP type by @hannes in #165

New Contributors

• @edward-burn made their first contribution in #153
• @toppyy made their first contribution in #168

Full Changelog: v0.10.2...v1.0.0

v0.10.2

What's Changed

• feat: Map NA to SQLNULL by @krlmlr in #143
• fix: Avoid R CMD check warning regarding SETLENGTH() and SET_TRUELENGTH() by @krlmlr in #145
• feat: Include rfuns extension by @krlmlr in #144
• fix: rel_sql(rel, "{{sql}}") works even on a read-only database by @Tmonster in #138
• feat: Implement n_distinct() for multiple arguments using duckdb structs by @lschneiderbauer in #122
• feat: Use latest tests from DBItest by @krlmlr in #148
• Change conversion for difftime to INTERVAL, not TIME by @hannes in #151

Full Changelog: v0.10.1...v0.10.2

v0.10.1

What's Changed

• Fix invalid regex in .Rbuildignore by @Tmonster in #108
• Remove std:: from unordered_map by @lnkuiper in #103
• ci: Update vendored sources nightly by @krlmlr in #82
• Driver registry by @krlmlr in #124
• fix: Don't run tests that invoke re2 by default by @krlmlr in #127
• README: Display different logo for light/dark mode by @szarnyasg in #129

New Contributors

• @lnkuiper made their first contribution in #103

Full Changelog: v0.10.0...v0.10.1

duckdb 0.10.0

What's Changed

• Fix REprintf warnings for R-devel by @krlmlr in #45
• feat: New private rel_to_parquet() to write a relation to parquet by @Tmonster in #46
• chore: Remove last instance of default_connection() by @krlmlr in #50
• chore: Update vendored sources to duckdb/duckdb@d51e1b0 by @krlmlr in #53
• chore: Update vendored sources to duckdb/duckdb@2414840 by @krlmlr in #57
• docs: use pkgdown BS5 by @maelle in #70
• Update README.md by @romainfrancois in #76
• chore: Sync duckplyr tests by @krlmlr in #78
• Add NEWS.md to CRAN by @olivroy in #48
• fix: Align the argument order of dbWriteTable() with the DBI specs by @eitsupi in #49
• test: Tweak tests for compatibility with v0.10.0 by @krlmlr in #84
• chore: Update vendored sources to duckdb/duckdb@d4c774b by @krlmlr in #85
• test: Add csv reading test for duckdb_read_csv(na.strings = ) by @Tmonster in #10
• feat: Update core to duckdb v0.10.0 by @krlmlr in #90
• fix: DBI::dbQuoteIdentifier() correctly quotes identifiers that start with a digit by @krlmlr in #92
• feat: Initial ALTREP support for LIST logical type by @romainfrancois in #77
• fix: dplyr::tbl() works again when a Parquet or CSV file is passed instead of a table name by @krlmlr in #91
• docs: Add list of contributors by @krlmlr in #94
• chore: Change directory location for extensions and secrets for v.0.10.0 release by @Tmonster in #73
• feat: New tbl_file() and tbl_query() to explicitly access tables and queries as dbplyr lazy tables by @krlmlr in #96

New Contributors

• @maelle made their first contribution in #70
• @romainfrancois made their first contribution in #76
• @olivroy made their first contribution in #48
• @eitsupi made their first contribution in #49

Full Changelog: v0.9.2...v0.10.0