Selecting Data from Nested JSONB Columns in PostgreSQL Using Regular Expressions and JSON Functions

Getting Distinct Values Inside Arrays with jsonb_path_query_array in PostgreSQL

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