WHERE Operators

Equality (Default)

When you pass a plain value to .where(), it uses strict equality:

TypeScript

pb.from(User).where('status', 'active').find();

// Explicit equality operator
pb.from(User).where('status', { $eq: 'active' }).find();

Dart

pb.from('users').where('status', 'active').find();

cURL (JSON DSL)

curl ... -d '{"action":"find","table":"users","query":{"status":"active"}}'

Comparison Operators

Operator	SQL Equivalent	TypeScript	Dart
$gt	>	{ $gt: 18 }	gt(18)
$gte	>=	{ $gte: 18 }	gte(18)
$lt	<	{ $lt: 100 }	lt(100)
$lte	<=	{ $lte: 100 }	lte(100)
$ne	!=	{ $ne: 'banned' }	neq('banned')
$eq	=	{ $eq: 'active' }	eq('active')
$between	BETWEEN x AND y	{ $between: [18, 65] }	between(18, 65)

TypeScript

// Ages between 18 and 65
pb.from(User).where('age', { $gte: 18, $lte: 65 }).find();

// Price between 10 and 100
pb.from(Product).where('price', { $between: [10, 100] }).find();

Dart

pb.from('users').where('age', between(18, 65)).find();
pb.from('products').where('price', between(10, 100)).find();

String Matching

Operator	SQL Equivalent	TypeScript	Dart
$like	LIKE (case-sensitive)	{ $like: '%john%' }	like('%john%')
$ilike	ILIKE (case-insensitive)	{ $ilike: '%john%' }	ilike('%john%')

TypeScript

// Case-insensitive search
pb.from(User).where('name', { $ilike: '%john%' }).find();

Dart

pb.from('users').where('name', ilike('%john%')).find();

List Operators

Operator	SQL Equivalent	TypeScript	Dart
$in	IN (...)	{ $in: ['a', 'b'] }	isIn(['a', 'b'])
$nin	NOT IN (...)	{ $nin: ['banned'] }	notIn(['banned'])

TypeScript

pb.from(User).where('role', { $in: ['admin', 'moderator'] }).find();
pb.from(User).where('status', { $nin: ['banned', 'deleted'] }).find();

Dart

pb.from('users').where('role', isIn(['admin', 'moderator'])).find();
pb.from('users').where('status', notIn(['banned', 'deleted'])).find();

Null Checks

TypeScript

pb.from(User).where('deleted_at', { $eq: null }).find();   // IS NULL
pb.from(User).where('email', { $ne: null }).find();         // IS NOT NULL

Dart

pb.from('users').where('deleted_at', isNull()).find();
pb.from('users').where('email', isNotNull()).find();

Full-Text Search

TypeScript

// Search across multiple columns
pb.from(Article).whereFts(['title', 'body'], 'typescript tutorial').find();

// With language configuration
pb.from(Article)
  .whereFts(['title', 'body'], 'développement web', { language: 'french' })
  .find();

Dart

pb.from('articles').where(r'$fts', {
  'fields': ['title', 'body'],
  'query': 'typescript tutorial',
}).find();

Supported languages: english, french, german, spanish, portuguese, and all PostgreSQL pg_catalog dictionaries.

JSONB Operators

For querying JSONB columns:

// Find where jsonb column contains a key
pb.from(Event).where('metadata->type', 'click').find();

// Nested path (text extraction)
pb.from(Event).where('metadata->user->id', userId).find();

OR Conditions

All .where() calls are combined with AND by default. To combine with OR, use the $or key in the JSON DSL:

TypeScript

pb.from(User).where({
  $or: [
    { status: 'active' },
    { role: 'admin' }
  ]
}).find();

cURL (JSON DSL)

curl ... -d '{"action":"find","table":"users","query":{"$or":[{"status":"active"},{"role":"admin"}]}}'

Multiple AND Conditions

// All .where() calls chain with AND
pb.from(User)
  .where('status', 'active')
  .where('age', { $gte: 18 })
  .where('role', { $in: ['admin', 'member'] })
  .find();