Hibernate can handle pagination just fine for both JPQL and SQL queries. However, that works for selecting records not for aggregate results.
As for portability, you can still can do it even with native SQL.
If you think your requirement should be supported by Hibernate, send us a Pull Request with an implementation for it. After all, that’s the beauty of open source software development.