A good ODM for DynamoDB in Python

DynamoDB is fast and incredibly scalable, but lacks a lot of common features you would expect from a more popular database like Postgres. One such issue is the absence of a good Object Document Mapper

I use FastAPI, which has great support for Pydantic, so it would be really nice to define my table schemas using Pydantic models like SQLModel does.

• Schema description with type-checking support, like PynamoDB
• Asyncio support, like asyncpg has

Possible solution shapes:

• Build a custom SQLAlchemy Dialect to support DynamoDB
• Monkeypatch PynamoDB with asyncio support
• Build from scratch using Pydantic and aioboto3