How to configure jOOQ Embeddable Types from SQL Query

Question

We’ve got a database where there are quite a lot of embedded types. Often the same embedded type occurs multiple times in the same table. The respective columns follow a naming pattern, so it’s easy to identify the different occurrences using an SQL query for example.

What’s the best way to configure jOOQ so that these embedded types gets mapped by the code generator? Note that our real db contains hundreds of tables, so manually configuring this is a no-go.

Fictional example:

create table t(amount int, unit varchar2(4), amount_pend int, unit_pend varchar(4));