Thanks for the reply @ChristianBeikov. That’s good to know that the LimitHandler is only for native queries. We are running DB2 z/OS, but our DBAs have the Application Compatibility level set to V11R1 which prevents us from using the offset keyword. Hibernate doesn’t seem to be aware of the compatibility setting.

To overcome this, I attempted to extend both DB2Dialect and DB2zDialect to override the getVersion() method but it causes an infinite recursion: https://hibernate.atlassian.net/browse/HHH-15957

This is our main blocker for completely embracing the new Spring Boot 3 🙂