Support Distinct functionality in Flutter SDK

[jassirr]

Is your feature request related to a problem? Please describe.
Currently, there is no way provided by the SDK to get the distinct records of a particular query.

Describe the solution you'd like

await supabaseClient
  .from(Constants.TABLE_NAME)
  .select('id', distinct: true)
  .eq('user_id', userId);

or

await supabaseClient
  .from(Constants.TABLE_NAME)
  .select('id',)
  .eq('user_d', roomId).distinct;

Additional context
This can reduce a burden of additionally not writing a method of providing the distinct results of queries.

[dshukertjr]

Hi @jassirr

Thanks for this feature request. Currently, PostgREST, the automatic API generation tool that Supabase use, does not provide a distinct select functionality. You can read some of the reasonings why it's not implemented here.

However, Group By is coming to PostgREST, which you could use to query similar results. You can read more about it here:
https://supabase.com/blog/postgrest-12#aggregate-functions

Note that aggregate functions are not yet supported on Supabase at this point.

I'm going to close this issue as aggregate functions will be available without requiring any updates on the supabase-flutter client library, but if you have further questions/ comments, feel free to leave them!

[anshunjain]

When will postgrest-12 be available on SUPABASE. My logs seem to suggest that we are on postgrest 11.2 @dshukertjr

[Vinzent03]

@anshunjain In case you still miss the update, here's the documentation