# Interface: CTEManagement

Defined in: packages/core/src/models/SelectQuery.ts:35

Fluent API for managing Common Table Expressions on a select query.

Implementations are expected to surface the same error behaviour exercised in packages/core/tests/models/SelectQuery.cte-management.test.ts.

Methods

addCTE()

addCTE(name, query, options?): this

Defined in: packages/core/src/models/SelectQuery.ts:36

Parameters

name

string

query

SelectQuery

options?

CTEOptions

Returns

this

---

removeCTE()

removeCTE(name): this

Defined in: packages/core/src/models/SelectQuery.ts:37

Parameters

name

string

Returns

this

---

hasCTE()

hasCTE(name): boolean

Defined in: packages/core/src/models/SelectQuery.ts:38

Parameters

name

string

Returns

boolean

---

getCTENames()

getCTENames(): string[]

Defined in: packages/core/src/models/SelectQuery.ts:39

Returns

string[]

---

replaceCTE()

replaceCTE(name, query, options?): this

Defined in: packages/core/src/models/SelectQuery.ts:40

Parameters

name

string

query

SelectQuery

options?

CTEOptions

Returns

this