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
  4ab9a9c4_1106_593b_a4df_f1f81ed18599["newYorkers()"]
  87dcb46e_0d95_8341_e760_d59ef620c68d["tables.ts"]
  4ab9a9c4_1106_593b_a4df_f1f81ed18599 -->|defined in| 87dcb46e_0d95_8341_e760_d59ef620c68d
  style 4ab9a9c4_1106_593b_a4df_f1f81ed18599 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/type-tests/sqlite/tables.ts lines 148–158

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