SQL databases often have custom quotation syntax for identifiers and strings
which make writing SQL queries error prone and cumbersome to do. glue_sql() and
glue_data_sql() are analogs to glue() and glue_data() which handle the
SQL quoting. glue_sql_collapse() can be used to collapse DBI::SQL() objects.
glue_sql(..., .con, .envir = parent.frame(), .na = DBI::SQL("NULL"))glue_data_sql(.x, ..., .con, .envir = parent.frame(), .na = DBI::SQL("NULL"))
A DBI::SQL() object with the given query.
[expressions]
Unnamed arguments are taken to be expression
string(s) to format. Multiple inputs are concatenated together before formatting.
Named arguments are taken to be temporary variables available for substitution.
[DBIConnection]: A DBI connection object obtained from
DBI::dbConnect().
[environment: parent.frame()]
Environment to evaluate each expression in. Expressions are
evaluated from left to right. If .x is an environment, the expressions are
evaluated in that environment and .envir is ignored. If NULL is passed, it is equivalent to emptyenv().
[character(1): ‘NA’]
Value to replace NA values
with. If NULL missing values are propagated, that is an NA result will
cause NA output. Otherwise the value is replaced by the value of .na.
[listish]
An environment, list, or data frame used to lookup values.
They automatically quote character results, quote identifiers if the glue
expression is surrounded by backticks '`' and do not quote
non-characters such as numbers. If numeric data is stored in a character
column (which should be quoted) pass the data to glue_sql() as a
character.
Returning the result with DBI::SQL() will suppress quoting if desired for
a given value.
Note parameterized queries are generally the safest and most efficient way to pass user defined values in a query, however not every database driver supports them.
If you place a * at the end of a glue expression the values will be
collapsed with commas. This is useful for the SQL IN Operator
for instance.
glue_sql_collapse() to collapse DBI::SQL() objects.