This DuckDB blog post on range joins might be relevant: https://duckdb.org/2022/05/27/iejoin.html