A good Django like ORM for FastAPI is Ormar [1]. I've got PG specific extensions to Ormar in [2].

1. https://github.com/collerek/ormar 2. https://github.com/tophat/ormar-postgres-extensions/