Remove Alias-in-Projection, replace it with SubqueryAlias

[jackwener]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

• Support SubqueryAlias better in planner #3927
• Replace Projection.alias with SubqueryAlias #2212

Describe the solution you'd like

• support more subqueryAlias wrap plan
• remove Alias-in-Projection, replace it with SubqueryAlias
• correct rule about subqueryAlias

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.