[Feature] Add support for ASOF join

[jirislav]

Description & use-case

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

Related issues

The most interesting is probably in DataFusion:

• https://github.com/apache/datafusion/issues/318

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[zclllyybb]

AFAIK, it's in our plan. maybe someday future it will be supported