AsOf joins

[derekmahar]

Does Arc support AsOf joins?

[xe-nvdk]

Does Arc support AsOf joins?

Hey @derekmahar thank you for your question.

Yes, Arc supports ASOF joins! Arc passes SQL through to DuckDB, which has native ASOF join support. No special configuration needed. Example:

SELECT p.time, p.symbol, p.price, t.quantity
FROM mydb.prices p
ASOF JOIN mydb.trades t 
  ON p.symbol = t.symbol 
  AND p.time >= t.time

This works today - Arc just validates for dangerous operations (DROP, DELETE, etc.) and then lets DuckDB handle the full SQL syntax including ASOF joins.