This is to track the different topic related to an improvement of the current SQL engine support in knitr.

It could be a fixup in current eng_sql or a new package project dedicated to SQL chunks. (I think we discussed it with @EdgaRuiz in the past)

KNITR

• Feature request: SQL engine with interlaced output #2093
• produce output for UPDATE-like queries using sql engine #2050
• Return tbl_lazy object from sql chunk in Rmd #1778
• SQL temp function being recognized as update query, returning no result #2359

R Markdown

• [FR] Run SQL chunk with DBI option immediate = TRUE ? rstudio/rmarkdown#2241
• Fail to detect dollar-quoted string constants in postgresql database rstudio/rmarkdown#2342

Quarto

• Article Layout Margin option for knitr sql code block seems buggy quarto-dev/quarto-cli#4869 (Fixup some knitr syntax in Lua to support SQL engine output  quarto-dev/quarto-cli#7829)