A different approach is reccursion: (Im using T-sql)

DECLARE @startDate date = '2019-04-01',
@endDate date = '2019-05-01'

;WITH cte AS (
SELECT @startDate as date_
UNION ALL
SELECT CAST(DATEADD(day,1,date_) as date)
FROM cte
WHERE date_...