如何在SQL中为从两个日期列提取的日期范围生成所有日期

SELECT 
    DATE_ADD(dates.start_date, INTERVAL seq.seq DAY) AS generated_date
FROM
    dates
JOIN
    (SELECT 
        (HUNDREDS.DIGIT * 100 + TENS.DIGIT * 10 + ONES.DIGIT) AS seq
    FROM
        (SELECT 0 AS DIGIT UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS ONES
    CROSS JOIN
        (SELECT 0 AS DIGIT UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS TENS
    CROSS JOIN
        (SELECT 0 AS DIGIT UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS HUNDREDS
    ) AS seq
WHERE
    DATE_ADD(dates.start_date, INTERVAL seq.seq DAY) <= dates.end_date
ORDER BY
    generated_date;