Currently we won't perform the rewrite if it's the anti case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows.