Generating a n date range
The following code demonstrates how to generate a date range for some $n$ range value. To use this approach, use any dummy table you may have on your database. Make sure the table has the right length for the date range.
In this example, we generate a date range of the first eight days of march. Starting from
SELECT
date('2025-03-01') + a.n * interval '1 day' as date_range
FROM (
SELECT
ROW_NUMBER() OVER() - 1 AS n
FROM
enrollments
LIMIT 8
) a;