I realized that only the native Hibernate bootstrapping mechanism allows
for passing custom SQL functions.
For JPA, we can extend the Dialect to register, but that's not always
desirable as it requires a code change
every time the user switches to a new Dialect version.
For this reason, I created this Jira issue:
Let me know if anyone has anything against implementing this feature.