Hi all! We are using Grails 5, and we use namedQueries pretty extensively. Specifically, we're using them a lot to chain lots of small criteria together to make for really flexible, fluid, and reusable query logic. We've been trying to move away from them and toward more

where

queries, as namedQueries are deprecated and not supported in Grails 6+ (from my understanding), but we're finding the lack of ability to chain them together really limiting. I'm curious if others have any similar experience or alternative suggestions. I've gone through lengthy discussions with ChatGPT and was kind of disappointed with the results. Any thoughts, ideas, or best practices welcome!

where queries are effectively DetachedCriteria and can be chained together- can you give some examples of where you are struggling?