ge and le for Field should create CheckConstraint

[throwable-one]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

from sqlalchemy import Column, Integer, CheckConstraint, create_engine
from sqlmodel import SQLModel, Field, Session


class UserWithSQLModel(SQLModel, table=True):
    id: int | None = Field(primary_key=True)
    age: int = Field(le=100, ge=18, nullable=False)


class UserWithConstraint(SQLModel, table=True):
    id: int | None = Field(primary_key=True)
    age: int = Field(sa_column=Column(Integer, CheckConstraint("age < 100 AND age > 18")))


if __name__ == "__main__":
    engine = create_engine("sqlite://")
    SQLModel.metadata.create_all(engine)
    with Session(engine) as session:
        user = UserWithSQLModel(age=200)
        # Uncomment this line to see it fails
        # user = UserWithConstraint(age=200)
        session.add(user)
        session.commit()

Description

For Integer field I already set limits using ge and le. It would be nice to have it as a constraint also.

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.31

Python Version

3.14

Additional Context

No response