A new package makes integrating SQL databases with Python code easy.
Sebastián Ramírez Montaño has built some of the best libraries currently around in Python. These include the excellent FastAPI (for building APIs) and Typer (for building command line interfaces). His trademark is great documentation, intuitive design, liberal use of type hints and high performance. His other packages build on top of other work (Pydantic, Uvicorn, Click etc) but make them more usable.
His new library, SQLmodel promises to improve the way we interact with SQL databases in Python. The project is designed to simplify using databases in FastAPI applications, by combining SQL Alchemy and Pydantic.
Having recently struggled with exactly this task, I'm really happy to see this project and looking forward to trying it out.