I have added a 'Boolean' type field to my DB tables in InfoWater, but cannot seem to figure out the correct syntax for a query based on it. I have tried all of the following, and each time I try to validate it says, "Invalid query statement or empty query result". I do have several pipes with ALT1=Yes, so I think it must be a problem with my syntax, or a bug.

What do I need to do to get this working?
I'm using InfoWater 12 Update #2 and ArcGIS 10.3.

Related to this, can I request a feature be added to the query builder to 'Get unique values' like the ArcMap query builder has?

PIPE->ALT1=YES
PIPE->ALT1='YES'
PIPE->ALT1=Yes
PIPE->ALT1='Yes'
PIPE->ALT1=TRUE
PIPE->ALT1='TRUE'
PIPE->ALT1=1
PIPE->ALT1='1'
STR( PIPE->ALT1)='1'
STR( PIPE->ALT1)='Yes'
STR( PIPE->ALT1)='YES'
STR( PIPE->ALT1)='TRUE'
STR( PIPE->ALT1)='True'