Add support for ASOF join

[jirislav]

When analyzing relational time-series data, it is essential to have the ability to join multiple datasets using time dimension by looking up at the value being closest in time.

Without proper query engine support, users are forced to implement inefficient work-around which is both slow & hard to read.

DuckDB has a great explanation here.

Many other popular databases & query engines support it:

• ClickHouse ASOF join
• QuestDB ASOF join
• Snowflake ASOF join
• Polars ASOF join
• DolphinDB ASOF join
• Kdb ASOF join
• Quasar ASOF join
• Kinetica ASOF join
• Timeplus ASOF join
• Shakti (k9) ASOF join

[findinpath]

cc @martint

[PranavRudra]

Hey Trino team, any update on this?

[piyushsethia07]

Hey Trino team, I am picking this up and will raise a commit request.