Package: duckdf
Type: Package
Title: SQL for Dataframes, but with Ducks
Version: 0.2.1
Authors@R: person("Phill", "Clarke", email = "phill@mimosadev.org",
    role = c("aut", "cre"))
Description: An SQL interface for R dataframes built on the DuckDB
        embedded analytical database. Dataframes are registered
        directly with an in-process DuckDB instance and queried with
        standard SQL, so analyses can join, filter, aggregate and
        reshape R objects with SQL while results are returned as
        dataframes, without copying data to an external database
        server. The package wraps the 'duckdb' R package with a
        DBI-compliant connection and provides a small, checked surface
        for the common register-query-unnregister workflow. The
        underlying engine and its vectorised execution model are
        described in Raasveldt and Mühleisen (2019)
        <doi:10.1145/3299869.3320212>.
License: AGPL-3
Encoding: UTF-8
Depends: R (>= 4.2.0)
Imports: DBI (>= 1.1.3), checkmate, duckdb (>= 1.5.6), jsonlite
Suggests: bench, data.table, dbplyr, dplyr, duckplyr, knitr, rmarkdown,
        sqldf, testthat (>= 3.0.0), tibble, withr
URL: https://github.com/phillc73/duckdf
BugReports: https://github.com/phillc73/duckdf/issues
Config/testthat/edition: 3
Config/roxygen2/version: 8.1.1
NeedsCompilation: no
Packaged: 2026-11-14 00:29:59 UTC; root
Author: Phill Clarke [aut, cre]
Maintainer: Phill Clarke <phill@mimosadev.org>
Repository: https://cran.r-universe.dev
Date/Publication: 2026-11-13 17:10:14 UTC
RemoteUrl: https://github.com/cran/duckdf
RemoteRef: HEAD
RemoteSha: e0be8640e0527bb49f24b5b9446101e9cece6157