prql code chunks use R code autocompletion and syntax highlighting

[andresrcs]

I guess prql autocompletion would need to be implemented on the RStudio IDE side but could it be possible to disable autocompletion as if it was R code and maybe use SQL syntax highlighting?

I just noticed this only happens when you have the "Source" markdown editor enabled on the RStudio IDE

[eitsupi]

Could you please open the issue in RStudio IDE repo as I believe that is a function of the IDE?

For example, I believe the following line, which I believe is part of the source code in the visual editor, defines all languages and may not work properly with code blocks that are not part of this definition.
https://github.com/quarto-dev/quarto/blob/973233520f1076b9eba9d2703648bf2a75ea90b7/packages/editor-core/src/languages.ts#L16-L116

For example, would something like the comment code block (knitr 1.37's new feature) not listed there work properly?
https://github.com/yihui/knitr/releases/tag/v1.37

[andresrcs]

Thanks, I'll give it a try.

I just wanted to be sure this was not something you could enable/disable on your side (I'm clearly not a developer, sorry)

[eitsupi]

Don't mind.

I think this feature is important for knitr's IDE integration in general, so I would be happy to link this issue to your open issue on IDE repo if you would like.

[eitsupi]

Thanks creating rstudio/rstudio#12767

[andresrcs]

They are asking for a PR for enabling prql syntax highlighting, would you be willing to tackle the issue?. As I said before, I'm not a developer so I don't have the required skill set to do it myself.

[eitsupi]

I replied to rstudio/rstudio#12767.