newYorkers() — drizzle-orm Function Reference

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

Function typescript DrizzleORM SQLDialects

Entity Profile

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

Dependency Diagram

graph TD
  6ec2ccc3_c2f4_3a11_5fa8_3a528bb5e151["newYorkers()"]
  19c69e5c_3d0f_1262_b345_f1446e5c039c["tables.ts"]
  6ec2ccc3_c2f4_3a11_5fa8_3a528bb5e151 -->|defined in| 19c69e5c_3d0f_1262_b345_f1446e5c039c
  style 6ec2ccc3_c2f4_3a11_5fa8_3a528bb5e151 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/type-tests/mysql/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`);
	});