I'm writing a report that needs to display a value per day. I have the start and end date for the query, but I wish to avoid missing days in case the table does not contain a value for a specific date.
I was thinking about creating a base date range table that holds all days between start and end, then left join it with the data table to show a value for each day.

I found a few scripts for mySQL, SQL Server, etc.. but none for SQLite.
Is there a way to quickly populate a table with a date range? 

Thanks