I am trying to get a 7day week of anniversaries.

Since you are using DBD::CSV, I'm assuming you're not concerned with speed. Might I suggest you are using the wrong tool? I recommend Date::Manip for it's event and calendar functionality. It might require a little bit of work to massage your CSV file into the new format, but not as much as crafting new SQL statements for each specific time period, IMO.