Better support for JSON columns

[Lob26]

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.ext.mutable import MutableDict
from sqlmodel import Field, Session, SQLModel

class Score(SQLModel, table=True):
    id: int | None = Field(default=None, primary_key=True)
    adjustments: dict[str, float] = Field(
        default={},
        sa_type=MutableDict.as_mutable(JSONB),
    )

def create(db: Session):
    score = Score()
    db.add(score)
    db.commit()
    db.refresh(score)
    return score

def update(db: Session, sc_id: int) -> Score:
    score = db.get(Score, sc_id)
    score.adjustments |= {"test": 1}
    db.add(score)
    db.commit()
    db.refresh(score)
    return score

if __name__ == "__main__":
    engine = ... # Whatever, just for safety
    with Session(engine) as db:
        sc = create(db)
        sc_ = update(db, sc.id)

        print(sc_.adjustments) # Prints the empty dict

Description

I know that SqlAlchemy have the flag_modified function, however, we should no use sqlalchemy for any minor inconvenience (If so then why should we use this to begin with?)

SQLModel should add the support for this type of updates

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

3.12.7

Additional Context

No response