I regularly need to manage NULL values in queries but the Designer doesn't provide a way to send NULL values to a named query when authoring them.
Typing in None or NULL enters a string of "None" or "NULL".
Please provide a way to test NULL values when authoring a NamedQuery in the designer.
I think having a string value of "NULL" as data would be pretty rare but if that can't work then right-click and select NULL value or '' or "" or keyword like NoValue would let us test queries with NULL values..