Postgresql – Filtering by JSON type field with Postgres and SQLAlchemy
I have a table test_table: Column | Type | ------------+------------------------+ id | integer | attributes | json | With content: id | attributes ----+---------------------------- 1 | {"a": 1, "b": ["b1","b2"]} 2 | {"a": 2, "b": ["b3"]} 3 | {"a": 3}…