Working with JSONB Arrays in PostgreSQL: A Deep Dive Into Array Functions, Unnesting, Filtering, and Indexing

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

Getting Distinct Values Inside Arrays with jsonb_path_query_array in PostgreSQL