[feature](nereids) Convert subqueries into algebraic expressions and …

[zhengshiJ]

…put them into the query tree

Proposed changes

Issue Number:

Problem summary

1.Originally, each expression would generate a scope, but now each node will generate a scope, reducing the repeated generation of scopes. 2.Added convert subqueries to algebraic expressions

Checklist(Required)

1. Does it affect the original behavior:
   • [ ] Yes
   • [x] No
   • [ ] I don't know
2. Has unit tests been added:
   • [x] Yes
   • [ ] No
   • [ ] No Need
3. Has document been added or modified:
   • [ ] Yes
   • [x] No
   • [ ] No Need
4. Does it need to update dependencies:
   • [ ] Yes
   • [x] No
5. Are there any changes that cannot be rolled back:
   • [ ] Yes (If Yes, please explain WHY)
   • [x] No

Further comments

If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...

[jacktengg]

Please rebase master to re-run P0 test

[wangshuo128]

I suggest first supporting analyzing and unnesting one type of subquery, e.g., converting InSubuqery to joins. Thus we could have a unit test to review the framework and main steps of unnesting subqueries.