SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create temp table filter as
    select 'foo' name, '+1 day' offset union
    select 'bar' name, '+3 day' offset union
    select 'baz' name, '+6 day' offset;
✓
create temp table data as
    select 'foo' name, '2021-12-05' day union
    select 'bar' name, '2021-12-06' day union
    select 'foo' name, '2021-12-07' day union
    select 'baz' name, '2021-12-08' day union
    select 'baz' name, '2021-12-09' day union
    select 'bar' name, '2021-12-10' day;
✓
SELECT d.* 
FROM data d INNER JOIN filter f
ON d.name = f.name AND d.day = date('2021-12-07', f.offset);


name
day


bar
2021-12-10


SELECT d.* 
FROM data d INNER JOIN filter f
ON d.day = date('2021-12-07', f.offset);


name
day


bar
2021-12-10

baz
2021-12-08