JSONB Queries

Contains

Check if a JSONB column contains a value:

pulsabase.from(User)
  .where('metadata', { $jsonb_contains: { role: 'admin' } })
  .find();

pulsabase.from('users')
    .where('metadata', jsonbContains({'role': 'admin'}))
    .find();

Check if a JSONB column has a specific key:

pulsabase.from(User)
  .where('preferences', { $jsonb_has_key: 'theme' })
  .find();

pulsabase.from('users')
    .where('preferences', jsonbHasKey('theme'))
    .find();

pulsabase.from('users')
    .where('preferences', jsonbHasAnyKey(['lang', 'timezone']))
    .find();