How strict is the IS TRUE SQL operator supposed to be? For example, BigQuery only allows an actual BOOL value, whereas every other dialect I’ve seen allows numerics as well, for example mysql or postgres allows select '1' is true, though perhaps that’s just for historical reasons because many databases don’t include an actual BOOL data type.