Using jOOQ’s Implicit Join From Within the JOIN .. ON Clause

SELECT is_a.udt_schema, is_a.udt_name, is_a.attribute_name, pg_a.attndims FROM information_schema.attributes AS is_a JOIN pg_attribute AS pg_a ON is_a.attribute_name = pg_a.attname JOIN pg_class AS pg_c ON is_a.udt_name = pg_c.relname AND pg_a.attrelid = pg_c.oid JOIN pg_namespace AS pg_n ON is_a.udt_schema = pg_n.nspname AND pg_c.relnamespace = pg_n.oid WHERE is_a.data_type = 'ARRAY' ORDER BY is_a.udt_schema, is_a.udt_name, is_a.attribute_name, is_a.ordinal_position The generated SQL looks slightly different from the original one, as jOOQ’s implicit JOIN algorithm will never flatten the JOIN tree in order to preserve any potential JOIN operator precedence, which is important in the event of there being LEFT JOIN , FULL JOIN or other operators present.