Did you try with Hibernate 6.1.4.Final yet? With the fix of https://hibernate.atlassian.net/browse/HHH-15517 it shouldn’t require temporary tables anymore. This issue really is just about making the use of global and persistent temporary tables nicer.