SQLAlchemy ORM Patterns

Use SQLAlchemy 2.0 stable APIs. Session.query() is a legacy compatibility API; new code uses select().

Model Definition

from decimal import Decimal
from uuid import UUID

from sqlalchemy import String
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column

class Base(DeclarativeBase):
    pass

class ProductModel(Base):
    __tablename__ = "products"