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
schema.table
.
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