BigQuery - Fill in Dates Between a Start and End Date

This script will produce different date lists based on the start date of each asset and ending at the end of last month.

e.g.
AssetId 1 starts on 2026-01-01 and AssetId 2 starts on 2026-03-01 and today's date is 2026-04-22. The output would be

SELECT
 AssetId,
 ArrayDate AS MonthStartDate,
 DATE_ADD(DATE_ADD(ArrayDate, INTERVAL 1 MONTH), INTERVAL -1 DAY) AS MonthEndDate
FROM (
  SELECT DISTINCT
    AssetId,
    ContractStartDate,
    DATE_ADD(DATE_ADD(CurrentUsageMonthEndDate, INTERVAL -1 MONTH), INTERVAL 1 DAY) AS NextDate
  from
    `<database>.<schema>.<table>`
  ),
  UNNEST(GENERATE_DATE_ARRAY(ContractStartDate, NextDate, INTERVAL 1 MONTH)) ArrayDate
ORDER BY
  AssetId,
  ArrayDate