[Hasnep]

Rmarkdown notebooks can contain SQL chunks, so you'd only need to use R to configure the connection. [1]

[1] https://bookdown.org/yihui/rmarkdown/language-engines.html#s...

[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.