I might be interpreting all this wrong, but I don't think the
column_property needs to be writable.
I think the situation is this:
Under Postgres, with HSTORE it's possible to INSERT/UPDATE/DELETE only
certain values from within the store.
Under SqlAlchemy, the entire object is
Actually, this is more correct for multi-key updates:
-- select before update
SELECT id, kv-'x' AS kv_x , kv-'y' AS kv_y , kv-'z' AS kv_z FROM
test_class ;
-- update 2 columns ; these 3 are identical
kvkv
UPDATE test_class SET kv = kv || hstore(ARRAY['z','zz','x','xx']);