As we have taken up newer versions of Hibernate, newer and more capable Hibernate "dialects" become available. We should look into basing our custom PostgreSQL dialect on Hibernate's PostgreSQL94Dialect instead of PostgreSQL82Dialect.
But it may be that we can abandon the custom dialect altogether. We have it to support UUID columns. But later versions of Hibernate have also improved their UUID support. We should see if we can just use a stock Hibernate dialect.
There was some discussion in Slack around 24-Feb-2020. https://dspace-org.slack.com/archives/C3SG47SGY/p1582567787002800