I'm relatively new to Python and I was looking for something like this. I do wonder if there is a well-known Python equivalent of Dapper: https://github.com/StackExchange/Dapper
https://stackoverflow.com/questions/13337629/create-an-insta...
For query building SQLAlchemy can do that and more.
I think that, with JSON support in most RDBMS, ORM as a concept has become way easier to handle. I come to think that this is the promise of the 90's Object oriented databases being fulfilled somehow.
[0]:https://stackoverflow.com/questions/6991135/what-does-it-mea...
You can achieve all that with JSON support in SQL, which most RDBMS have. You can then de-serialize JSON rows into Python objects. No need for an ORM.