Run a SQL query on a data frame or DuckDB table

RunQuery() has moved to workr::RunQuery(). This wrapper remains for backward compatibility in {gsm.core}.

Usage

RunQuery(strQuery, df, bUseSchema = FALSE, lColumnMapping = NULL)

Arguments

strQuery

character SQL query to run, containing placeholders "FROM df".

df

data.frame or tbl_dbi A data frame or DuckDB lazy table to use in the SQL query.

bUseSchema

boolean should we use a schema to enforce data types. Defaults to FALSE.

lColumnMapping

list a namesd list of column specifications for a single data.frame. Required if bUseSchema is TRUE.

Value

data.frame containing the results of the SQL query.

Examples

df <- data.frame(
  Name = c("John", "Jane", "Bob"),
  Age = c(25, 30, 35),
  Salary = c(50000, 60000, 70000)
)
query <- "SELECT * FROM df WHERE AGE > 30"

result <- workr::RunQuery(query, df)
#> [INFO] Creating a new temporary DuckDB connection.
#> duckdb keeps downloaded extensions and secrets in a temporary directory:
#> ℹ /tmp/Rtmpvj3eea/duckdb
#> This is removed when the R session ends.
#> • Extensions are re-downloaded each session.
#> • Secrets are lost.
#> ℹ Run duckdb(shared_home = TRUE) (or create ~/.duckdb) to keep them (suitable for most users).
#> ℹ Run duckdb(shared_home = FALSE) to accept the temporary directory (and silence this message).
#> ℹ See ?duckdb_storage for details and alternatives.
#> [INFO] SQL Query complete: 1 rows returned.
#> [INFO] Disconnected from temporary DuckDB connection.