Selecting an Element from a JSONB Array by Property Value in PostgreSQL

Getting Distinct Values Inside Arrays with jsonb_path_query_array in PostgreSQL

Updating Nested Arrays in PostgreSQL: A Step-by-Step Approach to Avoiding Unexpected Behavior