[keeganj]

I didn't know you could write SQL directly in Rmarkdown like this, very interesting. Thanks!

[pbowyer]

Same, when I've read the docs I've always got the impression that it was R only supported.

[PuddleOfSausage]

There are loads more supported via knitr. Scroll to the top of that linked page in this thread for the list.