Filter queries

This is the original style of queries established by existing Supabase client side libraries, including the Javascript client. It lets you chain multiple methods to form complex filters, although this can become a little untidy at times. Moreover, this form of querying does not let you combine multiple conditions using AND/OR clauses (currently).

Tip

Refer the PostgREST docs for more info about operators.

res = await client
    .from_("countries")
    .select("*")
    .filter("name", "eq", "India")
    .execute()

res = await client
  .from_("cities)
  .select("name, country_id")
  .gte("population", 1000)
  .lt("population", 10000)