regionalSales() — drizzle-orm Function Reference

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

Function typescript DrizzleORM DatabaseDrivers

Entity Profile

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

Dependency Diagram

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

Relationship Graph

Source Code

drizzle-orm/type-tests/pg/with.ts lines 21–28

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