rquery (version 0.2.0)

sql_node: Make a general SQL node.

Description

Make a general SQL node.

Usage

sql_node(source, exprs, mods = NULL)

Arguments

source

source to rename from.

exprs

SQL expressions

mods

SQL modifiers (GROUP BY, ORDER BY, and so on)

Value

sql node.

Examples

# NOT RUN {
my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
d <- dbi_copy_to(my_db, 'd',
                data.frame(AUC = 0.6, R2 = 0.2, z = 3))
eqn <- sql_node(d, "n" := "COUNT(1)")
cat(format(eqn))
sql <- to_sql(eqn, my_db)
cat(sql)
DBI::dbGetQuery(my_db, sql)
DBI::dbDisconnect(my_db)

# }