Details PomeloFoundation/Pomelo.EntityFrameworkCore.MySql#1309
Mainly any operator which is assigned to result of SqlUnaryExpression (representing only above operators) requires brackets to specify that IS NULL should be applied first. It works by chance for most basic case of a IS NULL == true