SQLite3 - Generate date time ranges using SQL recursive query

date_ranges.sql

DROP TABLE IF EXISTS date_ranges;
CREATE TEMP TABLE date_ranges (start_datetime DATETIME);

WITH RECURSIVE
    date_ranges(start_datetime) AS (
        VALUES('2011-05-01 00:00:00')
        UNION ALL
        SELECT datetime(start_datetime, '+1 month')
        FROM date_ranges WHERE start_datetime < datetime('now', '-1 month')
)
SELECT start_datetime, datetime(start_datetime, '+1 month') AS end_datetime
FROM date_ranges;