This simple nested query case is not supported yet, for non-join queries going into compileSingleQuery() logic. Will do this in next check-in.