newYorkers() — drizzle-orm Function Reference

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

Function typescript DrizzleORM DatabaseDrivers

Entity Profile

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

Dependency Diagram

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

Relationship Graph

Source Code

drizzle-orm/type-tests/pg/tables.ts lines 206–216

	.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`);
	});