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
  768f4056_3f68_300b_fe2a_2553382bf66a["topRegions()"]
  a4706dce_ae84_706c_8ff7_845a0df354a1["with.ts"]
  768f4056_3f68_300b_fe2a_2553382bf66a -->|defined in| a4706dce_ae84_706c_8ff7_845a0df354a1
  style 768f4056_3f68_300b_fe2a_2553382bf66a fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/type-tests/pg/with.ts lines 33–45

		.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),
					),
				)