regionalSales() — drizzle-orm Function Reference

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

Function typescript DrizzleORM RelationalQuery

Entity Profile

DrizzleORM→ RelationalQuery→ regionalSales() — drizzle-orm Function Reference

Dependency Diagram

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

Relationship Graph

Source Code

drizzle-orm/type-tests/geldb/with.ts lines 20–27

		.as((qb) =>
			qb
				.select({
					region: orders.region,
					totalSales: sql<number>`sum(${orders.amount})`.as('total_sales'),
				})
				.from(orders)
				.groupBy(orders.region)