The type of quoting needed varies by SQL dialect, so the .con argument is needed to determine what to use.
If you are always using the same type of database / connection you can write a simple wrapper function to avoid needing to pass .con, e.g.
library(DBI)
oracle_con <- dbConnect(ROracle::dbDriver("Oracle"), "scott", "tiger")
glue_orc <- function(..., .envir = parent.frame(), .na = DBI::SQL("NULL")) {
glue::glue_sql(..., .con = oracle_con, .envir = envir, .na = na)
}