sqlInterpolate not working with IN

[renkun-ken]

The following interpolation does not seem to be supported currently:

sqlInterpolate(con, "select * from table where name in ?names", names = c("name1", "name2"))

which is supposed to be translated into

select * from table where name in ('name1','name2')

[krlmlr]

You still can use SQL():

library(DBI)
sqlInterpolate(
  ANSI(),
  "select * from table where name in ?names",
  names = SQL("('a', 'b')")
)
#> <SQL> select * from table where name in ('a', 'b')

^{Created on 2018-10-01 by the reprex package (v0.2.1.9000)}

Would you like to add documentation and/or a test?

[renkun-ken]

@krlmlr Thanks! I file an PR to add documentation and a test for this.