Merge on ranges #2871
Description
I had a need today to merge on ranges and ended up using SQLite instead of Visidata.
Think about a use case like one sheet that has events that occur on a given date and another sheet that has periods with a start and end data. Right now, you can’t associate the events with the periods.
Algo-wise, it’s rather straightforward but UI-wise, I’m not sure what it would look like since it’s a bit more complicated than matching columns with matching keys, one column on one side needs to match to two columns on the other.
It would enable visidata to replace many database requests with a between though.