Add support for multiple filters / complex queries for Realtime and stream methods

[davoutuk]

For my Flutter app I was trying to build a dynamic filtering facility for a Supabase stream, and have discovered that an exception is thrown whenever more than one filter is applied.

Why this limit?

Is there any way around this? In my case I have want to apply two field filters and the exact two fields can vary according to user interactions

[dshukertjr]

@davoutuk
You can only have one filter on stream() due to the limitation on Supabase's realtime server currently. There is a issue on realtime repo discussing supporting more flexible queries supabase/realtime#303.

[getkey]

Also related: supabase/realtime#486

[hamishjohnson]

I have a workaround, by having a separate column, with the concatenated values, updated by a trigger. Easy if you just want 'eq' but you'll have to get creative if you want gt, lt etc.

[getkey]

Even better, as far as dirty hacks go 😅, is to use a generated column.

[leighajarett]

+1 this is something that FlutterFlow users have asked for :)