Hi, last year I did a performance audit of some applications and I found a new relatively common pattern - iteration over jsonb arrays. Because PL/pgSQL doesn't support this iteration directly, they used some combinations of jsonb_array_elements function and FOR IN SELECT.
The overhead of this can be relatively high, and I think we can support FOREACH json(b) arrays without some high cost. My idea is a support of syntax FOREACH target IN JSON ARRAY expression LOOP .. END LOOP target can be a scalar variable of any type - we can use cast rules used in JSON_TABLE What do you think about this proposal? Regards Pavel
