Looping in Bigquery

To Loop in Bigquery :

Instead of writing the following bulky one-liner:

SELECT ARRAY[OFFSET(0)], ARRAY[OFFSET(1)], ARRAY[OFFSET(2)], ARRAY[OFFSET(3)], ARRAY[OFFSET(4)], ARRAY[OFFSET(5)], ARRAY[OFFSET(6)], I am thinking of Shortening it to:

DECLARE n int64;
DECLARE f ?
DECLARE i INT64 DEFAULT 1;

SET n=7

WHILE i<n DO

SET f=CONCATE(f, ARRAY[OFFSET(i)] );

SET i = i +1;

END WHILE;


SELECT f based on f being a long concatenated string now.

Can it be done without errors in Bigquery?