duckplyr 1.1.0

This release improves compatibility with dbplyr and DuckDB.
See vignette("duckdb") for details.

Features

• Pass functions prefixed with dd$ directly to DuckDB, e.g., dd$ROW() will be translated as DuckDB's ROW() function (#658).

• New as_tbl() to convert to a dbplyr tbl object (#634, #685).

• Register Ark methods for Positron's "Variables" pane (@DavisVaughan, #661, #678). DuckDB tibbles are no longer displayed as data frames in the "Variables" pane due to a limitation in Positron. Use collect() to convert them to data frames if you rely on the viewer functionality.

• Translate n_distinct() as macro with support for na.rm = TRUE (@joakimlinde, #572, #655).

• Translate coalesce().

• compute() does not have a fallback, failures are reported to the client (#637).

• Implement slice_head() (#640).

Bug fixes

• Set functions like union() no longer trigger materialization (#654, #692).

• Joins no longer materialize the input data when the package is used with methods_overwrite() or library(duckplyr) (#641).

• Correct formatting for controlled fallbacks with Sys.setenv(DUCKPLYR_FALLBACK_INFO = TRUE).

Chore

• Bump duckdb and pillar dependencies.

• Use roxyglobals from CRAN rather than GitHub (@andreranza, #659).

• Bring tools and patch up to date (@joakimlinde, #647).

• Internal rel_to_df() needs prudence argument (#644).

• Fix sync scripts and add reproducible code (#639).

• Check loadability of extensions in test (#636).

Documentation

• Document slice_head() as supported.

• Add Posit's ROR ID (#592).

• Add vignette("duckdb") (#690).

• Add experimental badge.

• Verbose conflict_prefer() (#667, #684).

• Typos + clarification edits to "large" vignette (@mine-cetinkaya-rundel, #665).

Testing

• Skip tests using grep() or sub() on CRAN.