Integer64 & Integers treated differently by glue_sql

[carlganz]

glue_sql wraps integer64 values in quotes, but does not for integers. Feel free to close this if that is intentional.

library(glue)
library(bit64)

con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")

glue_sql(.con = con, "select {1}")
glue_sql(.con = con, "select {as.integer64(1)}")

Issue also appears with odbc and SQL Server instead of SQLite.

[hadley]

Providing a reprex and confirming and it's specifically a SQL issue:

library(glue)

con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")

glue_sql("select {1}", .con = con)
#> <SQL> select 1
glue_sql("select {bit64::as.integer64(1)}", .con = con)
#> <SQL> select '1'

glue("select {1}")
#> select 1
glue("select {bit64::as.integer64(1)}")
#> select 1

^{Created on 2023-01-25 with reprex v2.0.2}