Filter Operators

import { eq, gt, and } from 'drizzle-orm'

const orders = await db.select()
  .from(schema.orders)
  .where(and(
    eq(schema.orders.status, 'active'),
    gt(schema.orders.amount, 100)
  ))

import { gte, lte, and, between } from 'drizzle-orm'

// Range with individual operators
db.select().from(schema.orders).where(and(
  gte(schema.orders.amount, 10),
  lte(schema.orders.amount, 100)
))

// Same range with between
db.select().from(schema.orders).where(
  between(schema.orders.amount, 10, 100)
)

// Date comparison
db.select().from(schema.orders).where(
  gte(schema.orders.createdAt, new Date('2025-01-01'))
)

import { inArray, notInArray } from 'drizzle-orm'

db.select().from(schema.orders).where(
  inArray(schema.orders.status, ['active', 'pending', 'processing'])
)

db.select().from(schema.orders).where(
  notInArray(schema.orders.status, ['cancelled', 'archived'])
)

import { like, ilike } from 'drizzle-orm'

db.select().from(schema.customers).where(
  like(schema.customers.name, 'Order%')
)

db.select().from(schema.customers).where(
  ilike(schema.customers.email, '%@example.com')
)

import { isNull, isNotNull } from 'drizzle-orm'

// Active records (not soft-deleted)
db.select().from(schema.orders).where(isNull(schema.orders.deletedAt))

// Assigned records
db.select().from(schema.orders).where(isNotNull(schema.orders.assignedTo))

import { and, eq, gte } from 'drizzle-orm'

db.select().from(schema.orders).where(and(
  eq(schema.orders.status, 'active'),
  gte(schema.orders.amount, 100)
))

import { or, eq } from 'drizzle-orm'

db.select().from(schema.orders).where(or(
  eq(schema.orders.status, 'active'),
  eq(schema.orders.status, 'pending')
))

import { not, inArray } from 'drizzle-orm'

db.select().from(schema.orders).where(
  not(inArray(schema.orders.status, ['cancelled', 'archived']))
)

import { and, or, eq, gte, isNull } from 'drizzle-orm'

// Active or shipped, high value, not deleted
db.select().from(schema.orders).where(and(
  or(
    eq(schema.orders.status, 'active'),
    eq(schema.orders.status, 'shipped')
  ),
  gte(schema.orders.amount, 1000),
  isNull(schema.orders.deletedAt)
))