Enhance SortMergeJoinExec by implementing EagerJoinStream for the join #8273

Is your feature request related to a problem or challenge?

For a more maintainable SortMergeJoinExec, we can implement the common logic with EagerJoinStream since it is quite similar to what is done there.

Describe the solution you'd like

The state machine management of SortMergeJoinExec needs to be updated to align with the EagerJoinStream trait.

Describe alternatives you've considered

No response

Additional context

No response