Wrong escaping BLOB data with NULL for SQL Server

[krlmlr]

dbplyr::escape(
  blob::blob(raw(3), NULL),
  parens = FALSE,
  collapse = NULL,
  con = dbplyr::simulate_mssql()
)
#> <SQL> (0x000000)
#> <SQL> (0xNULL)

^{Created on 2022-08-23 by the reprex package (v2.0.1)}

Should be plain NULL .

[hadley]

I think it's doing it incorrectly for every backend:

dbplyr::escape(
  blob::blob(raw(3), NULL),
  parens = FALSE,
  collapse = NULL,
  con = dbplyr::simulate_postgres()
)
#> <SQL> (X'000000')
#> <SQL> (X'NULL')

^{Created on 2022-12-04 with reprex v2.0.2}