Visual Studio 2022 is an upgrade over its predecessor, the VS 2019. This Microsoft IDE is compatible with a lot of database technologies such as Azure, SQL, and SQLite, and has a perfect integration.

Note that GitHub Copilot isn’t optimized for R; the documentation says Copilot works “especially well” for Python, JavaScript, TypeScript, Ruby, Go, C#, and C++. However, Copilot does make R code ...