Is your feature request related to a problem or challenge?

When the column which is the output ordering of the input plan of a projection disappears after the projection, the order information is lost. Therefore, unnecessary SortExecs may be added.
For example, if the input plan has an output ordering of column 'a', and there is a projection of 'a+1', the order requirement of 'a' is still satisfied.

Describe the solution you'd like

We can estimate the new expressions' orders by using the input plan output ordering and equivalence properties, and in the case of dropping the output ordering, we can assign one of them as the new output ordering.

Describe alternatives you've considered

No response

Additional context

No response