escape {dbplyr} | R Documentation |
Escape/quote a string.
escape(x, parens = NA, collapse = " ", con = NULL) sql_vector(x, parens = NA, collapse = " ", con = NULL)
x |
An object to escape. Existing sql vectors will be left as is,
character vectors are escaped with single quotes, numeric vectors have
trailing |
parens, collapse |
Controls behaviour when multiple values are supplied.
Default behaviour: lists are always wrapped in parens and separated by commas, identifiers are separated by commas and never wrapped, atomic vectors are separated by spaces and wrapped in parens if needed. |
con |
Database connection. If not specified, uses SQL 92 conventions. |
# Doubles vs. integers escape(1:5) escape(c(1, 5.4)) # String vs known sql vs. sql identifier escape("X") escape(sql("X")) escape(ident("X")) # Escaping is idempotent escape("X") escape(escape("X")) escape(escape(escape("X")))