JOOQ materialized views

Tags: , ,

is it possible to create materialized views using the JOOQ builder? Something like this



In jOOQ 3.14, not yet:

But you can use plain SQL templating to work around this limitation, to at least get some type safety in your statement:

ctx.execute("create materialized view view_name as {0}", select);

Source: stackoverflow