ident() takes unquoted strings and flags them as identifiers. ident_q() assumes its input has already been quoted, and ensures it does not get quoted again. This is currently used only for for schema.table.

ident(...)

ident_q(...)

is.ident(x)

Arguments

...

A character vector, or name-value pairs

x

An object

Examples

# SQL92 quotes strings with ' escape_ansi("x")
#> <SQL> 'x'
# And identifiers with " ident("x")
#> <IDENT> x
escape_ansi(ident("x"))
#> <SQL> `x`
# You can supply multiple inputs ident(a = "x", b = "y")
#> <IDENT> x #> <IDENT> y
ident_q(a = "x", b = "y")
#> <IDENT> x #> <IDENT> y