duckdb (version 0.6.0)

rel_sql: Run a SQL query on a DuckDB relation object

Description

Run a SQL query on a DuckDB relation object

Usage

rel_sql(rel, sql)

Value

the now aggregated duckdb_relation object

Arguments

rel

the DuckDB relation object

sql

a SQL query to run, use _ to refer back to the relation

Examples

con <- DBI::dbConnect(duckdb())
rel <- rel_from_df(con, mtcars)
rel2 <- rel_sql(rel, "SELECT hp, cyl FROM _ WHERE hp > 100")