June 11, 2025

[github-actions]

Feature

The following GoogleSQL functions are now available in preview:

• The ARRAY_FIRST function returns the first element of the input array.
• The ARRAY_LAST function returns the last element of the input array.
• The ARRAY_SLICE function returns an array that contains consecutive elements from the input array.

https://cloud.google.com/bigquery/docs/release-notes#June_11_2025