How i can reused/compose part of a JOOQ query in a repository method? has a good answer for multiple queries that start the same way with different later components.

I am working with a database that handles null values very poorly. Instead of using nullable strings, I want to use a fixed, very rare value (essentially a UUID) as a placeholder for null.

I am getting null with below syntax