>I had assumed you knew and had only looked at the SQL too often - so I only left the relevant parts in. Sometimes I am too lazy/cryptic, I know...
I guess I would go with the NVL() approach and frame that into a method of the data class so it would generate the proper SQL syntax based on the backend.