And I want to filter the table to get only the rows that have the stream value in the

context

array being equal to:

kjzl6cwe1jw148482np90z6odirjwf66c6h97t5z52p7a7bpcig8iju43323q7y

what would be the supabase query to achieve this?

This column looks like a array with json inside of it, not sure if you can filter data by that column.

Looks very similar to this one. https://stackoverflow.com/questions/51267155/in-postgresql-how-can-i-select-rows-where-a-jsonb-array-contains-objects Try it out in the SQL Editor and if it works you can wrap it in a

rpc

.

Thank you for those examples! 🙏