如何在Snowflake中创建月份范围？

WITH RECURSIVE month_range AS (
  SELECT DATE_TRUNC('MONTH', CURRENT_DATE) AS month_start,
         DATE_TRUNC('MONTH', CURRENT_DATE) + INTERVAL '1 MONTH' - INTERVAL '1 DAY' AS month_end
  UNION ALL
  SELECT month_start - INTERVAL '1 MONTH',
         month_end - INTERVAL '1 MONTH'
  FROM month_range
  WHERE month_start > '开始日期'
)
SELECT month_start, month_end
FROM month_range
WHERE month_start >= '开始日期' AND month_end <= '结束日期'
ORDER BY month_start;