Optimizing JSON Data Queries with PostgreSQL's JSONB Data Type

Updating Second-Level Keys of JSON Sets in Postgres Using Common Table Expressions

Getting Distinct Values Inside Arrays with jsonb_path_query_array in PostgreSQL