WITH DATE_TBL AS ( 
    SELECT
        '2023-04-01' AS DAY
    UNION ALL 
    SELECT
        DATE (DAY, '+1 days')
    FROM
        DATE_TBL 
    WHERE
        DAY < '2023-04-31'
) 
select
    *
FROM
    DATE_TBL
;