The knitr SQL Engine Grows Up

Note

This is one of a few posts on new features from a recent four-day knitr backlog sprint; see that post for the full details of the sprint.

knitr’s sql engine lets you write a SQL query in a code chunk, run it against a DBI connection, and drop the result into your document. It has been a bit bare-bones for a long time. This cycle a group of contributors pushed it a long way forward. If you write reports against a database, several of these are going to feel like they should …