Query: Lift table from subquery when joining if no additional operations

[smitpatel]

When doing join, we pushdown the right SelectExpression if it has various operations applied to SelectExpression in order to apply them before join. One of them is existence of order by clause. But we also remove order by from subquery when there is no skip take as that ordering is irrelevant and lifted outside already. This causes a query to be pushed down but then erases order by so we have a flat select expression with projection and single table. We could avoid pushdown and generate flat join table.

[smitpatel]

Fixed by #26476