Refactor the CTE related optimization using the sequence operator

## Enhancement

We've introduced the sequence operator to handle the dependency relationship between the CTEs.
Now we can merge the CTE's optimization process into the main optimization to enable further optimization such that the predicate push down of the CTE is not complete.

It's a known issue of the CTE's optimization.