Backend with Python

API layer

FastAPI

https://fastapi.tiangolo.com/

Flask

https://flask.palletsprojects.com/en/stable/

https://auth0.com/blog/developing-restful-apis-with-python-and-flask/

Database access

SQL → Code

https://sqlc.dev/

ORMs

SQL-first

https://hyperflask.dev/blog/2025/11/11/blending-sql-and-python-with-sqlorm/

Traditional

https://www.kubeblogs.com/build-databases-with-sqlalchemy-and-alembic/

Schema migration

https://www.pingcap.com/article/best-practices-alembic-schema-migration/?utm_source=chatgpt.com