Implement startsWith and endsWith functions for arrays

Why it matters

These functions allow users to check if an array begins or ends with a specified sequence of elements, simplifying queries that require matching array prefixes or suffixes. This enhances array manipulation capabilities and improves query expressiveness and readability.

How to use it

Use the startsWith(array, prefixArray) function to determine if an array starts with the given prefix array, and endsWith(array, suffixArray) to check if an array ends with the given suffix array within your SQL queries.