Support Case-Insensitive Array Element Matching in PostgREST API

[bcihanc]

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 array columns in a more flexible and straightforward manner.

This feature would greatly enhance the capabilities of Supabase for applications that rely heavily on array data types and need to perform complex searches efficiently.

Thank you for considering this request, and I appreciate all the hard work the team is putting into making Supabase better every day!

Best regards.