Avoid concatenating record batches in joins to alleviate memory pressure

### Is your feature request related to a problem or challenge?

Many of the joins (such as HashJoin) concatenate input record batches into a single record batch for ease of index accounting, but this causes huge memory pressure issues when the datasets are large.

### Describe the solution you'd like

If the joins were able to preserve the original record batches without concatenation, this would help alleviate OOMs on large queries.

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Start by tracing join implementations such as HashJoin and locating where input record batches are concatenated for index accounting. Review how joins could preserve original batches, then validate that large joins avoid the reported memory pressure while retaining correct results.

Written by the indexing model from the issue text.