Hand-authored SQL queries can be clumsy to use, since databases and software applications tend to live in separate conceptual worlds. It’s hard to model how your app and your data work together.

Positron is Posit's new, free IDE for data science. Users can work with Python and R. It explicitly does not replace RStudio.