Grails/GORM sequence per table in Postgres

Today I answered a question that outlines how to implement a custom dialect for Hibernate so that your Grails application can use a unique sequence per table within Postgres. I am surprised that not many people have run into this issue as it's a pretty common requirement for applications.

Real-time Grails Help

You may not know, but there is a very active #grails IRC channel on freenode. Come join us and discuss all things Grails. Stay awhile and help others, and learn a few new things too! Hope to see you there!

Multi-Associative GORM Criteria with Projections

I have three domain classes: Lead, Submission and BuyerLog:

I have a need to get the number of duplicate leads which share the same leadBuyer (in the BuyerLog domain class). Here is the SQL:

I want to do this using GORM / Criteria Builder. Here's my final code:

Thanks to schmolly159 on the #grails freenode IRC channel for the examples and continued help.