Want this on documents from bucket
WITH step AS (2)
SELECT ARRAY {"sequence":pos, "name":"xyz", "body": SUBSTR(h.name , v, step)}
FOR pos:v IN ARRAY_RANGE(0,LENGTH(h.name),step)
END AS obj
FROM `travel-sample`.inventory.hotel AS h
LIMIT 1;