@cole or @edgararuiz Is there a feature request for this for SQL code chunks? I get that dplyr handles this well, but it is very limiting for SQL code chunks in RMarkdown to only accept single length variables. I'm pretty sure the reason this happens is that the knitr language engine prevents SQL injection by via the sqlInterpolate function, which in turn uses dbQuoteString. This is good protection, but it does not play nicely with the sorts of cases considered here (which I think will be common).
@cole the thread you linked to was about something related but different. @edgararuiz do you think the FR here should go to knitr (where the language engine is defined) or to DBI (which powers dbQuoteString and sqlInterpolate?
Thanks!
Aaron