Returns an array of the same size as the original array, with the elements in reverse order.
ARRAY_REVERSE(<arr>)
<arr>
SELECT ARRAY_REVERSE([ 1, 2, 3, 6 ]) AS res;
Returns: [6,3,2,1]
[6,3,2,1]