RightMark Join support to SortMergeJoin execution

[comphead]

@jonathanc-n did a great job adding a RightMark Join, it would be needed to add the same support for Sort Merge Join

It is needed to add RightMark Join support to SortMergeJoin execution as well

Originally posted by @comphead in #16083 (comment)

[jonathanc-n]

take

[jonathanc-n]

@comphead I was reviewing whats already there and it should be finished after #17651. Can be closed.