Filters

where is shared by every read, count, exists, update, delete, and upsert. It is typed against your table's columns and relations.

Equality shorthand

The simplest filter is a direct value — it means "equals":

await client.users.findMany({
	where: { active: true, name: 'Alice' },
});

That is identical to the explicit form:

await client.users.findMany({
	where: { active: { equals: true } },
});

Multiple keys are combined with AND.

String filters

String columns accept equality, membership, and pattern operators:

await client.users.findMany({
	where: {
		name: { contains: 'ali', mode: 'insensitive' },
		email: { endsWith: '@example.com' },
	},
});

Numeric and date filters

Numbers, bigints, and dates accept range comparisons:

await client.users.findMany({
	where: {
		id: { gte: 100, lte: 200 },
	},
});

Boolean filters

await client.users.findMany({
	where: { active: { equals: true } },
});

Boolean columns support equals and not.

Null and negation

Nullable columns accept null directly, and any operator can be negated with not:

await client.posts.findMany({
	where: {
		deletedAt: null, // IS NULL
		title: { not: { contains: 'draft' } },
	},
});

Logical operators

Combine conditions with AND, OR, and NOT. They nest arbitrarily:

await client.users.findMany({
	where: {
		AND: [
			{ active: true },
			{
				OR: [
					{ email: { endsWith: '@company.com' } },
					{ name: { startsWith: 'Admin' } },
				],
			},
		],
	},
});

Filtering by relations

where also reaches across relations with some / every / none (to-many) and is / isNot (to-one). That has its own page:

Dropping to raw Drizzle SQL

When you need an expression the structured filter does not model, pass a Drizzle SQL fragment straight into where:

import { eq } from 'drizzle-orm';
import { users } from './schema';

const user = await client.users.findFirst({
	where: eq(users.id, 1),
});

Anything that produces a Drizzle SQL / SQLWrapper is accepted, so you keep the full expressive power of Drizzle for the cases that need it.