Transforming JSON Arrays into ID-Indexed Objects in PostgreSQL

Getting Distinct Values Inside Arrays with jsonb_path_query_array in PostgreSQL