Support Case-Insensitive Array Element Matching in PostgREST API

Hello, I’m currently working with a table that contains an array column in Supabase, and I need to perform case-insensitive searches within the elements of this array. Unfortunately, I found that the current PostgREST API does not directly support case-insensitive matching for array elements using the cs (contains) operator or other similar methods. To achieve this, I’ve had to create a custom PostgreSQL function (RPC) that performs a case-insensitive search by unnesting the array and applying the ILIKE operator. While this works, it would be much more efficient and user-friendly if there were built-in support for this kind of operation directly through the PostgREST API. Feature Request: I would like to request the addition of a feature that allows for case-insensitive matching of array elements directly within the Supabase API, without the need for custom RPCs. This could be similar to the ILIKE operator but applicable to arrays, allowing developers to search within arra…