SQLServer does not support LIKE operator in binary comparison

When pushing Spark query to MsSqlServer engine we sometimes construct SQL query that has a LIKE operator as a part of the binary comparison operation, which is not permitted in SQL Server syntax. 

For example a query 

SELECT * FROM people WHERE (name LIKE "s%") = 1

will not execute on MsSQLServer.

These queries should be detected and not pushed to execution in MsSqlServer.