[VL][Spark-4.0] Add support for LeftSingle join for correlated scalar subqueries

[Surbhi-Vijay]

Description

Spark has introduced new join type LeftSingle which triggers changes in query execution in certain scenarios.

Single join is a left outer join that checks that there is at most 1 build row for every probe row.

Refer:
[SPARK-49653][SQL] Single join for correlated scalar subqueries
commit: apache/spark@3c81f07

Gluten version

None