Feature: approximate join / as-of join / reindex like #20
Description
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.