As suggested by @bricelam in #22916 (comment), we should translate string.IsNullOrEmpty using LIKE (`WHERE s IS NULL OR s LIKE '').

Our current implementation (which comes from Relational) is buggy, since it returns true for whitespace-only strings.