Consider SQLModel to consolidate Pydantic models with SQLAlchemy schemas

[nanotaboada]

Description

Explore the use of SQLModel to unify SQLAlchemy schemas and Pydantic models in the FastAPI project. SQLModel simplifies data modeling by integrating both functionalities while leveraging Python type hints.

Acceptance Criteria

• Research SQLModel’s compatibility with FastAPI and SQLAlchemy.
• Compare SQLModel’s benefits against the current implementation.
• Provide a proof of concept by converting one model to SQLModel.
• If viable, propose a migration plan for the full transition.

Resources

• 🔗 SQLModel Documentation