Add guards for unsupported subqueries join plan, optimize the possible subqueriese

It is always safe to throw out a non-inline projection node at the top of the bottom fragment? WHY?