So you thought arrays should start at 1 instead of 0.
Conversation
Replying to
But then our SQL forefathers thought 1 was the right place to start (dba.stackexchange.com/questions/1259). Hence BigQuery with #standardSQL allows you to choose between OFFSET (0) and ORDINAL (1) when working with arrays. cloud.google.com/bigquery/docs/. I love SQL, but...
1