Ah, now I understand. Unfortunately that isn't an option in Firebird,
CTEs only support select.
Mark
On 08-03-2021 10:19, Christian Beikov wrote:
Take a look into
org.hibernate.query.sqm.mutation.internal.cte.CteStrategy which uses DML
in CTEs to implement a delete for polymorphic entities as well as for
cascades.
--
Mark Rotteveel