# Interface: CTERestorationResult
Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:40
Result of CTE SQL restoration containing executable query and metadata
Properties ​
name ​
name:
string
Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:42
Name of the CTE
executableSql ​
executableSql:
string
Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:44
Executable SQL query including all dependencies
dependencies ​
dependencies:
string[]
Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:46
Array of CTE names that this CTE depends on (in execution order)
warnings ​
warnings:
string[]
Defined in: packages/core/src/transformers/CTEQueryDecomposer.ts:48
Any warnings encountered during restoration