Using filters
Filters can be used on select()
, update()
, and delete()
queries.
If a Stored Procedure returns a table response, you can also apply filters.
Filters must be applied to the end of queries and can also be chained together to produce advanced queries.
final res = await supabase
.from('cities')
.select('name, country_id')
.eq('name', 'The Shire') // Correct
.execute();
final res = await supabase
.from('cities')
.eq('name', 'The Shire') // Incorrect
.select('name, country_id')
.execute();