Pulling projections into semijoins is not a good idea: leads to name conflicts with the left input.
Pulling projections into semijoins is not a good idea: leads to name
conflicts with the left input.

ulricha/dsh