backend-duckdb: DuckDB SQL backend for dbplyr
In duckdb: DBI Package for the DuckDB Database Management System

backend-duckdb

R Documentation

DuckDB SQL backend for dbplyr

Description

This is a SQL backend for dbplyr tailored to take into account DuckDB's possibilities. This mainly follows the backend for PostgreSQL, but contains more mapped functions.

Usage

simulate_duckdb(...)

translate_duckdb(...)

Arguments

...

Any parameters to be forwarded

Examples


library(dplyr, warn.conflicts = FALSE)
con <- DBI::dbConnect(duckdb(), path = ":memory:")

dbiris <- copy_to(con, iris, overwrite = TRUE)

dbiris %>%
  select(Petal.Length, Petal.Width) %>%
  filter(Petal.Length > 1.5) %>%
  head(5)

DBI::dbDisconnect(con, shutdown = TRUE)

duckdb documentation built on Nov. 17, 2023, 5:08 p.m.