SQLAlchemy Skill

Think of SQLAlchemy models as ActiveRecord (Rails) models — they map to DB tables and support associations, validations (via constraints), and queries. Alembic = Rails migrations.

Model Definition (ORM, Declarative Style)

from sqlalchemy import String, Integer, ForeignKey, func
from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column, relationship
from datetime import datetime

class Base(DeclarativeBase):
    pass

class User(Base):
    __tablename__ = "users"