First 50 fibonacci numbers in BQ

fibonacci_50.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];
    numbers.shift();
    numbers.push(new_num);
    n -= 1;
  }
  return numbers[n];
""";

WITH raw_values as (
  SELECT *
  FROM UNNEST(GENERATE_ARRAY(0, 50, 1)) AS num
)
select
  num,
  fibonacci(num) as fib_n
from raw_values
where num <= 10 or mod(num, 10) = 0;