refactor: split regular and existence join in hash join

[2010YOUY01]

Is your feature request related to a problem or challenge?

Regular joins (inner/left/right/full) and existence joins (anti/semi/mark) are different relational operations; separating them can potentially make them simpler and easier to maintain.

The following issue describes the why. I believe it's a different problem, but with exactly the same core philosophy, and it provides a more detailed writeup.

• [EPIC] Split Aggregation Logic into Dedicated Streams #22710

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[jayzhan211]

@peterxcli Let's look at what we can do on the hash join side that would help with #24768.