buildWithCTE() — drizzle-orm Function Reference

Architecture documentation for the buildWithCTE() function in dialect.ts from the drizzle-orm codebase.

Function typescript DrizzleORM SQLDialects called by 3

Entity Profile

DrizzleORM→ SQLDialects→ buildWithCTE() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  36b61a5b_7f68_2e43_5760_d461578993f6["buildWithCTE()"]
  9c5eee4c_4b78_a585_4038_d710de212097["MySqlDialect"]
  36b61a5b_7f68_2e43_5760_d461578993f6 -->|defined in| 9c5eee4c_4b78_a585_4038_d710de212097
  6603fb43_ff6f_ad94_0e94_0f152d804075["buildDeleteQuery()"]
  6603fb43_ff6f_ad94_0e94_0f152d804075 -->|calls| 36b61a5b_7f68_2e43_5760_d461578993f6
  8f9fa658_edb5_f102_51bb_be11ee53973b["buildUpdateQuery()"]
  8f9fa658_edb5_f102_51bb_be11ee53973b -->|calls| 36b61a5b_7f68_2e43_5760_d461578993f6
  8ae83588_d5c3_3834_94e9_82ba6770d1a1["buildSelectQuery()"]
  8ae83588_d5c3_3834_94e9_82ba6770d1a1 -->|calls| 36b61a5b_7f68_2e43_5760_d461578993f6
  style 36b61a5b_7f68_2e43_5760_d461578993f6 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/src/mysql-core/dialect.ts lines 106–118

	private buildWithCTE(queries: Subquery[] | undefined): SQL | undefined {
		if (!queries?.length) return undefined;

		const withSqlChunks = [sql`with `];
		for (const [i, w] of queries.entries()) {
			withSqlChunks.push(sql`${sql.identifier(w._.alias)} as (${w._.sql})`);
			if (i < queries.length - 1) {
				withSqlChunks.push(sql`, `);
			}
		}
		withSqlChunks.push(sql` `);
		return sql.join(withSqlChunks);
	}