使用SQL生成一系列日期

WITH RECURSIVE date_series(start_date, end_date, current_date) AS (
  SELECT
    '2022-01-01'::date AS start_date,
    '2022-01-10'::date AS end_date,
    '2022-01-01'::date AS current_date
  UNION ALL
  SELECT
    start_date,
    end_date,
    current_date + INTERVAL '1 day'
  FROM
    date_series
  WHERE
    current_date + INTERVAL '1 day' <= end_date
)
SELECT
  current_date
FROM
  date_series;