Solutionunvalidated
Join the table to a per-row json_to_recordset call using a lateral table function, e.g. SELECT json_array_elements(x.codes)->>'code' FROM my_table mt, json_to_recordset(mt.json_column->'findings') AS x(codes json);.
f8b60deb-393a-433c-8337-421c1be19327
Join the table to a per-row json_to_recordset call using a lateral table function, e.g. SELECT json_array_elements(x.codes)->>'code' FROM my_table mt, json_to_recordset(mt.json_column->'findings') AS x(codes json);.