topRegions() — drizzle-orm Function Reference

Architecture documentation for the topRegions() function in with.ts from the drizzle-orm codebase.

Function typescript DrizzleORM DatabaseDrivers

Entity Profile

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

Dependency Diagram

graph TD
  3f4c99c0_33f8_46f6_0d06_f1aaabb68bd1["topRegions()"]
  75f2c353_40af_2ce9_31a7_9e2237405a87["with.ts"]
  3f4c99c0_33f8_46f6_0d06_f1aaabb68bd1 -->|defined in| 75f2c353_40af_2ce9_31a7_9e2237405a87
  style 3f4c99c0_33f8_46f6_0d06_f1aaabb68bd1 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/type-tests/geldb/with.ts lines 32–44

		.as((qb) =>
			qb
				.select({
					region: orders.region,
					totalSales: orders.amount,
				})
				.from(regionalSales)
				.where(
					gt(
						regionalSales.totalSales,
						db.select({ sales: sql`sum(${regionalSales.totalSales})/10` }).from(regionalSales),
					),
				)