dbplyr (version 0.0.0.9001)

sql: SQL escaping.

Description

These functions are critical when writing functions that translate R functions to sql functions. Typically a conversion function should escape all its inputs and return an sql object.

Usage

sql(...)
is.sql(x)
as.sql(x)

Arguments

...

Character vectors that will be combined into a single SQL expression.

x

Object to coerce

Examples

# 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")))