Regarding the additional joins, I think Calcite's Correlate [1] is the
equivalent of the dependent/binding join that appears in the database
literature. Currently, Correlate does not extend Join but we could
possibly reconsider this decision if necessary.
Best,
Stamatis
[1]
I would regard this as two separate but related things: a new SQL syntax for
joins, and a new relational operator. It is definitely worth keeping them
separate; the operator will not map 1-1 to the syntax, may require its input to
input to be sorted, and of course we would want queries to be
Hello,
Seems that this new kind of JOIN named AS OF is very useful for processing
time-series data. Here is some example documentation from Snowflake:
https://docs.snowflake.com/en/sql-reference/constructs/asof-join
The semantics is similar to a traditional join, but the result always contains