在Google big查询中有没有一个函数可以找到一个历年的ISO周号/周号的第一个日期和最后一个日期？

SELECT DATE_TRUNC(DATE '2023-01-01', WEEK) AS first_day_of_week_1_2023;

SELECT DATE_ADD(DATE_TRUNC(DATE '2023-01-01', WEEK), INTERVAL 6 DAY) AS last_day_of_week_1_2023;

WITH RECURSIVE Weeks AS (
  SELECT 1 AS week_number, DATE_TRUNC(DATE '2023-01-01', WEEK) AS start_date
  UNION ALL
  SELECT week_number + 1, DATE_ADD(start_date, INTERVAL 7 DAY)
  FROM Weeks
  WHERE week_number < 53 -- ISO 8601标准中一年最多有53周
)
SELECT week_number,
       start_date AS first_day_of_week,
       DATE_ADD(start_date, INTERVAL 6 DAY) AS last_day_of_week
FROM Weeks
WHERE EXTRACT(YEAR FROM start_date) = 2023;