Both following queries match and remove all rows (ie. with both true/false/null values):
DELETE WHERE BooleanValue
DELETE WHERE NOT BooleanValue

Where column in foreign table is:
booleanvalue boolean OPTIONS (NATIVE_TYPE 'BOOLEAN')
and view:
BooleanValue boolean