Filters

Filters narrow which rows are returned by .select(), updated by .update(), or deleted by .delete(). Chain as many as you need.

Reference

Every filter below works against Postgres. See the compatibility notes underneath for what’s different when the database is MySQL instead — its mysql-rest sidecar implements a smaller, PostgREST-compatible subset. Unsupported filters aren’t silently dropped: mysql-rest returns a 400 explaining what it didn’t understand.

Method	SQL equivalent
.eq('col', value)	col = value
.neq('col', value)	col != value
.gt('col', value)	col > value
.gte('col', value)	col >= value
.lt('col', value)	col < value
.lte('col', value)	col <= value
.like('col', pattern)	col LIKE pattern
.ilike('col', pattern)	col ILIKE pattern
.is('col', null)	col IS NULL
.in('col', [a, b])	col IN (a, b)
.contains('col', [a])	col @> ARRAY[a] (array column)
.containedBy('col', [a, b])	col <@ ARRAY[a, b]
.filter('col', 'op', value)	Escape hatch for arbitrary ops

On MySQL: .eq, .neq, .gt, .gte, .lt, .lte, .like, .is, and .in all work. .ilike has no case-insensitive equivalent — use .like() (MySQL’s default collation is already case-insensitive for most text columns). .contains / .containedBy are Postgres array operators and aren’t available. .filter() only recognizes the operators in the table above, not arbitrary raw PostgREST syntax.

Examples

// Equality
await massi.from('users').select('*').eq('role', 'admin')

// Range
await massi.from('orders').select('*').gte('total', 1000).lt('total', 5000)

// Pattern match (case-insensitive)
await massi.from('products').select('*').ilike('name', '%phone%')

// Null check
await massi.from('posts').select('*').is('deleted_at', null)

// In a set
await massi.from('posts').select('*').in('status', ['draft', 'review'])

// Multiple filters (AND)
await massi
  .from('posts')
  .select('*')
  .eq('published', true)
  .gte('created_at', '2025-01-01')
  .order('created_at', { ascending: false })

All filters are AND-ed together. OR queries require the .filter() escape hatch with raw PostgREST syntax or a Postgres view.