# Class: CTECollector

Defined in: packages/core/src/transformers/CTECollector.ts:25

A visitor that collects all CommonTable instances from a SQL query structure. This includes tables from:

• WITH clauses
• Subqueries
• Inline queries
• UNION queries
• Value components that may contain queries

Implements

• SqlComponentVisitor<void&gt;

Constructors

Constructor

new CTECollector(): CTECollector

Defined in: packages/core/src/transformers/CTECollector.ts:31

Returns

CTECollector

Methods

getCommonTables()

getCommonTables(): CommonTable[]

Defined in: packages/core/src/transformers/CTECollector.ts:108

Get all collected CommonTables

Returns

CommonTable[]

---

collect()

collect(query): CommonTable[]

Defined in: packages/core/src/transformers/CTECollector.ts:120

Parameters

query

SelectQuery

Returns

CommonTable[]

---

visit()

visit(arg): void

Defined in: packages/core/src/transformers/CTECollector.ts:130

Main entry point for the visitor pattern. Implements the shallow visit pattern to distinguish between root and recursive visits.

Parameters

arg

SqlComponent

Returns

void

Implementation of

SqlComponentVisitor.visit

---

visitPartitionByClause()

visitPartitionByClause(partitionBy): void

Defined in: packages/core/src/transformers/CTECollector.ts:487

Parameters

partitionBy

PartitionByClause

Returns

void

---

visitValueList()

visitValueList(valueList): void

Defined in: packages/core/src/transformers/CTECollector.ts:491

Parameters

valueList

ValueList

Returns

void