# Interface: DecomposedCTE

Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:14

Interface representing a decomposed CTE with executable query

Properties

name

name: string

Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:16

Name of the CTE

---

query

query: string

Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:18

Executable SQL query for this CTE (includes dependencies)

---

dependencies

dependencies: string[]

Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:20

Array of CTE names that this CTE depends on

---

dependents

dependents: string[]

Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:22

Array of CTE names that depend on this CTE

---

isRecursive

isRecursive: boolean

Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:24

Whether this CTE is recursive