Reference material for ARRAY_FLATTEN function
ARRAY_FLATTEN(<array>)
<array>
ARRAY
SELECT ARRAY_FLATTEN([ [ [ 1, 2 ] ], [ [ 2, 3 ], [ 3, 4 ] ] ])
[ [ 1, 2 ], [ 2, 3 ], [ 3, 4 ] ]