Example of recursive date generation in SQL

gistfile1.sql

CREATE VIEW some_dates AS
WITH RECURSIVE dates(i, d) AS (
    VALUES (1, DATE('1970-01-01'))
    UNION ALL
    SELECT i + 1, d + 1 DAY FROM dates WHERE d < DATE('2070-12-31')
)
SELECT
    d.d        AS a_date,
    YEAR(d.d)  AS a_year,
    MONTH(d.d) AS a_month,
    DAY(d.d)   AS a_day
FROM dates;