any(is.na(X)) is translated incorrrectly for MSSQL  #1273

FWIW any(is.na(X)) is also translated incorrrectly for MSSQL to MAX(CAST(IIF(("X" IS NULL), 1, 0) AS BIT)), which generates error: Operand data type bit is invalid for max operator.

Originally posted by @carlganz in #1239 (comment)