Example

Model:

>>> from crate.client.sqlalchemy.types import Object, ObjectArray
>>> from uuid import uuid4

>>> class Character(Base):
...     __tablename__ = 'characters'
...     id = sa.Column(sa.String, primary_key=True, default=gen_key)
...     name = sa.Column(sa.String)
...     quote = sa.Column(sa.String)
...     details = sa.Column(Object)
...     more_details = sa.Column(ObjectArray)
...     name_ft = sa.Column(sa.String)
...     quote_ft = sa.Column(sa.String)

We try to update a Character:

>>> char = session.query(Character).filter_by(name='Arthur Dent').one()
>>> char.details['gender'] = 'manly man'
>>> char.details['field_A']['sub_field_a'] = 'value_aaaa'
>>> session.commit()
>>> session.refresh(char)

SQLAlchemy generates the following query:

UPDATE characters SET details['gender'] = 'manly man' WHERE analysis.id = '955ce9c7-e85f-489d-b48c-bf6e216c10fe';

But char.details['field_A']['sub_field_a'] is not taken in account in the query. The expected query is:

UPDATE characters SET details['gender'] = 'manly man', details['field_A']['sub_field_a'] = 'value_aaaa' WHERE analysis.id = '955ce9c7-e85f-489d-b48c-bf6e216c10fe';