I like Tortoise ORM. Django-style models, async-first, clean. But I wanted more speed on read-heavy paths without reaching for SQLAlchemy, so I built yara-orm: a Tortoise-style async ORM where the model and query layer is Python, but the engine — connection pooling, parameter binding, and row decoding — is written in Rust (PyO3 over tokio-postgres and rusqlite).

The API is exactly what you'd expect:

from yara_orm import Model, YaraOrm, fields, in_transaction

class Author(Model):

id = fields.IntField(pk=True)