dbQuoteLiteral

[hadley]

Needs to convert:

• integers
• doubles (adding trailing .0, and handling Inf, -Inf)
• logical
• dates
• date/times
• strings
• SQL strings

All need to convert NA to NULL.

Could replace dbQuoteString()

[hannes]

perhaps also raw/BLOB?

[krlmlr]

Should also preserve names (#173).

[krlmlr]

@hannesmuehleisen: Is the X'xxxx' syntax for BLOB literals sufficiently standardized to warrant inclusion in DBI?

    if (is.list(x)) {
      blob_data <- vapply(
        x,
        function(x) {
          if (is.null(x)) "NULL"
          else if (is.raw(x)) paste0("X'", paste(format(x), collapse = ""), "'")
          else {
            stop("Lists must contain raw vectors or NULL", call. = FALSE)
          }
        },
        character(1)
      )
      return(SQL(blob_data))
    }

[hannes]

The X is standardized (ISO/IEC 9075-2:2008(E)) at least in SQL 2008 which I have here. It also says both upper- and lowercase is ok.

[krlmlr]

Thanks!

[hadley]

FWIW I think SQL 2003 support is still kind of shaky, so it's quite possible that many databases won't support this. (But it's still fine to have in DBI)