sqlmodel

To unify FastAPI request schemas and SQLAlchemy database models, define SQLModel table and data models within a single class hierarchy using table=True, eliminating duplicate code by leveraging Pydantic and SQLAlchemy together.

Manage per-request sessions in FastAPI with SQLModel by handling the engine lifecycle and yielding a session per route request, ensuring safe and scalable data access while preventing session leaks.

Define one-to-many and many-to-many relationships in SQLModel using minimal boilerplate linkage classes, allowing you to perform common queries and join tables directly within your typed Python data models.

SQLModel does not replace SQLAlchemy and Pydantic but combines them, enabling you to create typed API schemas and relational database structures using one coherent class hierarchy for rapid FastAPI development.

Initialize databases and handle migrations with SQLModel by defining your table models and generating initialization scripts, satisfying requirements for relational model definitions and proper database setup in Python apps.

Use unified data models instead of separate schemas and tables in FastAPI when you need to rapidly develop typed APIs with minimal wiring, reducing boilerplate by representing both API structures and relational tables in one hierarchy.