Imagine you have a cached query that you want to be invoked everyday between 6AM and 7AM

As of now you need to create it between 6AM and 7AM and set the refresh_rate to 24h.

Consider adding an initial_date / next_refresh_at / whatever the interface will be to enable specifying not only the refresh rate but also the initial delay.