sqlmodel

SQLModel is a library for interacting with SQL databases using Python objects. It acts as a thin layer on top of Pydantic and SQLAlchemy, designed to be highly compatible with both, as well as with the FastAPI framework. Key capabilities include: - Code Duplication Reduction: A single model definition serves as both a SQLAlchemy model for database interaction and a Pydantic model for data validation. - Developer Experience: Built with Python type annotations to provide extensive editor support, including autocompletion and inline error detection. - Extensibility: Provides full access to the underlying power of SQLAlchemy and Pydantic. - Database Operations: Supports defining tables as Python classes, creating rows as class instances, and performing queries using a session-based approach.