SQL escaping/quoting generics
These generics translate individual values into SQL. The core
generics are DBI::dbQuoteIdentifier() andDBI::dbQuoteString
for quoting identifiers and strings, but dbplyr needs additional
tools for inserting logical, date, date-time, and raw values into
queries.
sql_escape_logical(con, x) sql_escape_date(con, x) sql_escape_datetime(con, x) sql_escape_raw(con, x)
Other generic:
db-sql,
db_connection_describe(),
db_copy_to()
con <- simulate_dbi()
sql_escape_logical(con, c(TRUE, FALSE, NA))
sql_escape_date(con, Sys.Date())
sql_escape_date(con, Sys.time())
sql_escape_raw(con, charToRaw("hi"))Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.