Sqlalchemy使用json_set更新特定JSON字段

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.dialects.mysql import JSON

engine = create_engine("mysql+pymysql://username:password@host:port/database")
Session = sessionmaker(bind=engine)
session = Session()

Base = declarative_base()

class MyModel(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    json_data = Column(JSON)

from sqlalchemy.sql import text

stmt = text("UPDATE my_table SET json_data = JSON_SET(json_data, '$.field', :new_value) WHERE id = :record_id")
stmt = stmt.bindparams(new_value='new_value', record_id=1)

session.execute(stmt)
session.commit()