newYorkers2() — drizzle-orm Function Reference

Architecture documentation for the newYorkers2() function in tables.ts from the drizzle-orm codebase.

Function typescript DrizzleORM DatabaseDrivers

Entity Profile

DrizzleORM→ DatabaseDrivers→ newYorkers2() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  8f11cc48_089e_c135_b06f_9e1c08ea01ed["newYorkers2()"]
  998b0a13_62af_9408_d100_2bb61b49b6b9["tables.ts"]
  8f11cc48_089e_c135_b06f_9e1c08ea01ed -->|defined in| 998b0a13_62af_9408_d100_2bb61b49b6b9
  style 8f11cc48_089e_c135_b06f_9e1c08ea01ed fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/type-tests/pg/tables.ts lines 547–557

	.as((qb) => {
		const sq = qb
			.$with('sq')
			.as(
				qb.select({ userId: users.id, cityId: cities.id })
					.from(users)
					.leftJoin(cities, eq(cities.id, users.homeCity))
					.where(sql`${users.age1} > 18`),
			);
		return qb.with(sq).select().from(sq).where(sql`${users.homeCity} = 1`);
	});