and() — drizzle-orm Function Reference

Architecture documentation for the and() function in conditions.ts from the drizzle-orm codebase.

Function typescript DrizzleORM SQLDialects calls 1

Entity Profile

DrizzleORM→ SQLDialects→ and() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  a70813f1_21d0_091a_8841_404ffe20513b["and()"]
  57e6e1af_7162_5b6e_bfcf_9d9935f60d31["conditions.ts"]
  a70813f1_21d0_091a_8841_404ffe20513b -->|defined in| 57e6e1af_7162_5b6e_bfcf_9d9935f60d31
  d6f243fd_6cbd_d4f3_d0bc_78f4860f53cb["join()"]
  a70813f1_21d0_091a_8841_404ffe20513b -->|calls| d6f243fd_6cbd_d4f3_d0bc_78f4860f53cb
  style a70813f1_21d0_091a_8841_404ffe20513b fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/src/sql/expressions/conditions.ts lines 105–125

export function and(
	...unfilteredConditions: (SQLWrapper | undefined)[]
): SQL | undefined {
	const conditions = unfilteredConditions.filter(
		(c): c is Exclude<typeof c, undefined> => c !== undefined,
	);

	if (conditions.length === 0) {
		return undefined;
	}

	if (conditions.length === 1) {
		return new SQL(conditions);
	}

	return new SQL([
		new StringChunk('('),
		sql.join(conditions, new StringChunk(' and ')),
		new StringChunk(')'),
	]);
}