sum of fibonacci in BQ

sum_fibonacci.sql

CREATE TEMP FUNCTION fibonacci(n INT64)
RETURNS INT64
LANGUAGE js AS
"""
  var numbers = [0, 1]
  while (n > 1) {
    var new_num = (numbers[0] + numbers[1]) % 1000000;
    numbers.shift();
    numbers.push(new_num);
    n -= 1;
  }
  return numbers[n];
""";

WITH raw_values as (
  SELECT *
  FROM UNNEST(GENERATE_ARRAY(0, 1000)) AS num
)
select
  sum(fibonacci(num)) as result
from raw_values;