An extremely useful feature for a time-series database is the ability to do an "approximate join" where for each value in the left table, the closest value from the right table is selected based on some sorted index (usually time).
DuckDB calls this AS-OF Join.
Pandas calls this reindex_like.
An extremely useful feature for a time-series database is the ability to do an "approximate join" where for each value in the left table, the closest value from the right table is selected based on some sorted index (usually time).
DuckDB calls this AS-OF Join.
Pandas calls this reindex_like.