Add Settings.transformPatterns for combining ARRAY lambda functions

[lukaseder]

jOOQ 3.20 introduces ARRAY lambda functions, like ARRAY_FILTER(arr, e -> predicate):

• Add support for lambda accepting array functions #16499

It will be interesting to study how we can transform nested ARRAY lambda functions in order to simplify them, e.g.

• ARRAY_FILTER
• ARRAY_MAP
• ARRAY_SORT (to be investigated)
• Combinations of the above (to be investigated)

Examples

ARRAY_FILTER

-- Before
ARRAY_FILTER(
  ARRAY_FILTER(a, e -> p1(e)),
  e -> p2(e)
);

-- After
ARRAY_FILTER(a, e -> p1(e) AND p2(e))

ARRAY_MAP

-- Before
ARRAY_MAP(
  ARRAY_MAP(a, e -> m1(e)),
  e -> m2(e)
);

-- After
ARRAY_MAP(a, e -> m2(m1(e)))