[bigquery]ファンクションの利用例

CREATE TEMP FUNCTION FROM_DATE() AS (DATE('2021-09-08'));
CREATE TEMP FUNCTION TO_DATE() AS (DATE('2021-09-15'));

SELECT
  *
FROM
  dataset.table
WHERE
  target_date BETWEEN FROM_DATE() AND TO_DATE()