In other words, you want to expand a query expression into a regular time series. There is a book by Richard Snodgrass, "Developing Time-Oriented Database Applications in SQL" that may be helpful if you can find a copy. I understand it is out of print.
You could create a table function to accomplish what you want. There is probably another solution using a join on the sys_calendar.calendar view, but I'm not clever enough with SQL (and haven't absorbed enough of the Snodgrass book) to tell you specifically how to do that.
I did something similar for missing dates, the most efficient way was:
Calculate the next date using OLAP-functions and then CROSS JOIN to a table/query with all days WHERE date_col between start_date and next_date. There are several special cases you must take care off, so it's not that efficient on larger amounts of data...