Timeseries JOINs

[david542542]

It would be great to be able to add JOINs common to timeseries databases, such as:

• ASOF
• LT
• SPLICE

All three are variations of the ASOF join, described as:

ASOF joins are used on time series data to join two tables based on timestamp where timestamps do not exactly match.

Examples of the three different join types are shown here from the QuestDB documentation: https://questdb.io/docs/reference/sql/join/. kdb and InfluxDB would also have something similar.

[david542542]

@hannes

This items is the same as #3207, so it can be closed.