Tracking: complete join-time/residual condition support for native joins

[weimingdiit]

Describe

Native join support is still incomplete when join conditions need to be evaluated
during or after the physical join.

Today, support is fragmented across different join implementations and join types.
This makes native planning less predictable and leaves some joins either unsupported
or only partially supported depending on the algorithm selected.

This tracking issue groups the remaining work needed to make join-condition support
more complete and consistent in the native engine.

Scope

This issue tracks the following work items:

• Implement native support for inner residual join conditions on SMJ/SHJ #2193
• Support native residual conditions for inner broadcast hash joins #2194
• Add join-time residual condition support for native outer joins #2195
• Add join-time residual condition support for native semi and anti joins #2196

Goal

The goal is to make native join condition handling consistent across major join
algorithms and join types, so that:

• native planning is less fragmented
• fallback behavior is reduced
• correctness is preserved for condition evaluation across join variants
• test coverage clearly captures supported vs unsupported cases