Note that in ORM, a native update query is mapped to a table and ORM flushes first (and second?) level caches as a protection. We should reuse the same mechanism.

Yes, my hope is that we can re-use this mechanism as is and just plug in a custom native query plan implementation which delegates to the dialect. Then we should get the flush management from ORM.