I'm working on a project where I want to be able to define and manage a database schema and create an API client. In Python, I have used SQLAlchemy, an Object-Relational Mapping (ORM) library along with Flask for this purpose. I find SQLAlchemy's features and flexibility very useful, especially its ability to map Python classes to database tables, and support for defining and implementing APIs.
I'm wondering if there is a similar ORM for R, or if there is an R interface to SQLAlchemy that I could use. I'm aware of
dbplyr for database manipulation in R, but as far as I understand, it's not an ORM like SQLAlchemy.
Any insights or recommendations would be greatly appreciated. Thank you in advance for your help!