ORM

Built on async/await patterns, enabling non-blocking database operations that are ideal for modern Python web frameworks like FastAPI and Starlette, as shown in the quickstart example.

Works seamlessly with Postgres, MySQL, and SQLite using async drivers (asyncpg, aiomysql, aiosqlite), providing flexibility across different backend setups without vendor lock-in.

Leverages SQLAlchemy for robust query building and compatibility with Alembic migrations, ensuring reliable database schema management and ecosystem familiarity.

Uses Typesystem for field validation and type safety, offering data integrity checks out of the box without additional configuration, as highlighted in the features.