Add ASOF JOIN Support for full_sorting_join Algorithm

Why it matters

This feature enhances ClickHouse's join capabilities by enabling the use of the full_sorting_join algorithm with ASOF JOIN operations. It improves performance and flexibility when performing time-series or interval-based joins that require approximate matching.

How to use it

To use this feature, specify ASOF JOIN in your query and ensure the join uses the full_sorting_join algorithm, which will now support ASOF semantics automatically without additional configuration.