[aikah]

> it handles multi-mapping (eg mapping users and posts from a single query)

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.