A check for exact equality (null, true, false), finds all rows whose value on the stated column
exactly match the specified value
.
is_
and in_
filter methods are suffixed with _
to avoid collisions with reserved keywords.
final data = await supabase
.from('cities')
.select('name, country_id')
.is_('name', null);
final data = await supabase
.from('cities')
.update(\{ 'name': 'Mordor' \})
.is_('name', null);
final data = await supabase
.from('cities')
.delete()
.is_('name', null);
// Only valid if the Stored Procedure returns a table type.
final data = await supabase
.rpc('echo_all_cities')
.is_('name', null);