duckdb (version 0.6.0)

rel_filter: Lazily filter a DuckDB relation object

Description

Lazily filter a DuckDB relation object

Usage

rel_filter(rel, exprs)

Value

the now filtered duckdb_relation object

Arguments

rel

the DuckDB relation object

exprs

a list of DuckDB expressions to filter by

Examples

con <- DBI::dbConnect(duckdb())
DBI::dbExecute(con, 'CREATE MACRO gt(a, b) AS a > b')
rel <- rel_from_df(con, mtcars)
rel2 <- rel_filter(rel, list(expr_function("gt", list(expr_reference("cyl"), expr_constant("6")))))