【MariaDB】指定の日付が一式揃ったカラムを簡単に作成するSQL【SELECT】

WITH dates AS (
  SELECT generate_series(
    '2023-01-01'::date,
    '2023-01-31'::date,
    '1 day'
  ) as date
)
SELECT 
  *
FROM 
  dates
ORDER BY 
  dates.date

WITH RECURSIVE date_list (date) AS (
    SELECT '2023-01-01'
  UNION ALL
    SELECT DATE(date + INTERVAL 1 DAY)
    FROM date_list
    WHERE date < '2023-01-31' 
 )
SELECT 
  *
FROM 
  date_list
ORDER BY 
  date;