Piccolo is a modern, async query builder and ORM for Python, with lots of batteries included.
pip install piccolo
Experiment with queries:
piccolo playground run
Give me an ASGI web app!
piccolo asgi new
FastAPI, Starlette, BlackSheep, and Litestar are currently supported, with more coming soon.
Piccolo has some tutorial videos on YouTube, which are a great companion to the docs.