This query (or better this definition plus native query) worked for years and it still works under 5.x, now you say it is wrong, honestly I’m confused

I’m not the only finding this regression, here a like to an issue on SpringBoot

https://github.com/spring-projects/spring-boot/issues/33557#issuecomment-1373839422