some databases such as Oracle do not support boolean literals or boolean at all as a user accessible type

SQL Server doesn't have boolean literals like that, hence the (1=0) trick