Class: SQLCalculationBuilder

Defined in: lang-sql/src/visitors/calculation-builder.ts:14

Extends the core CalculationBuilder with SQL-specific plan operators, treating each as a scalar subquery that returns at most one value.

Extends

• CalculationBuilder

Implements

• SQLPlanVisitor<CalculationParams>

Constructors

Constructor

new SQLCalculationBuilder(vmap, db): SQLCalculationBuilder

Defined in: core/dist/visitors/calculation-builder.d.ts:79

Parameters

Parameter	Type	Description
vmap	Record<string, PlanVisitor<CalculationParams>>	Per-language visitor map used for recursive descent.
db	DortDBAsFriend	Database instance providing access to the language manager.

Returns

SQLCalculationBuilder

Inherited from

CalculationBuilder.constructor

Properties

db

protected db: DortDBAsFriend

Defined in: core/dist/visitors/calculation-builder.d.ts:78

Database instance providing access to the language manager.

Inherited from

CalculationBuilder.db

---

vmap

protected vmap: Record<string, PlanVisitor<CalculationParams>>

Defined in: core/dist/visitors/calculation-builder.d.ts:76

Per-language visitor map used for recursive descent.

Inherited from

CalculationBuilder.vmap

Methods

processFnArg()

protected processFnArg(arg): ASTIdentifier | CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:110

Converts a single plan.FnCall argument (which may be a wrapped operator or a bare identifier) to CalculationParams, relaxing the assertMaxOne constraint to ret1 when the argument's acceptSequence flag is set.

Parameters

Parameter	Type
arg	ASTIdentifier | PlanOpAsArg

Returns

ASTIdentifier | CalculationParams

Inherited from

CalculationBuilder.processFnArg

---

processItem()

protected processItem(item): ASTIdentifier | CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:98

Converts an OpOrId to either a raw ASTIdentifier or a CalculationParams by dispatching through vmap, unwrapping identity FnCall(ret1, [x]) wrappers along the way.

Parameters

Parameter	Type
item	OpOrId

Returns

ASTIdentifier | CalculationParams

Inherited from

CalculationBuilder.processItem

---

processLiteralConditional()

protected processLiteralConditional(cond, whenthens, defaultCase?): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:122

Attempts to fold a CASE expression at compile time when cond is a literal. Returns the pre-computed CalculationParams if the matching branch is also a literal, or null when runtime evaluation is still required.

Parameters

Parameter	Type
cond	CalculationParams
whenthens	[ASTIdentifier | CalculationParams, ASTIdentifier | CalculationParams][]
defaultCase?	ASTIdentifier | CalculationParams

Returns

CalculationParams

Inherited from

CalculationBuilder.processLiteralConditional

---

processQuantifiedFn()

protected processQuantifiedFn(operator, children): (...args) => boolean

Defined in: core/dist/visitors/calculation-builder.d.ts:104

Builds a runtime implementation for a plan.FnCall that contains ANY / ALL plan.Quantifier arguments, performing the cartesian-product evaluation over quantified argument sequences.

Parameters

Parameter	Type
operator	FnCall
children	(ASTIdentifier | CalculationParams)[]

Returns

(...args) => boolean

Inherited from

CalculationBuilder.processQuantifiedFn

---

processWhenThen()

protected processWhenThen(item): [ASTIdentifier | CalculationParams, ASTIdentifier | CalculationParams]

Defined in: core/dist/visitors/calculation-builder.d.ts:115

Converts a CASE [when, then] pair to CalculationParams or raw identifiers.

Parameters

Parameter	Type
item	[OpOrId, OpOrId]

Returns

[ASTIdentifier | CalculationParams, ASTIdentifier | CalculationParams]

Inherited from

CalculationBuilder.processWhenThen

---

toItem()

protected toItem(op): MapToItem

Defined in: core/dist/visitors/calculation-builder.d.ts:88

Wraps op in a plan.MapToItem node, reparenting op under the new node and updating op's previous parent to point at the wrapper.

Parameters

Parameter	Type
op	PlanTupleOperator

Returns

MapToItem

Inherited from

CalculationBuilder.toItem

---

visitAggregate()

visitAggregate(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:140

Parameters

Parameter	Type
operator	AggregateCall

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitAggregate

Inherited from

CalculationBuilder.visitAggregate

---

visitBidirectionalRecursion()

visitBidirectionalRecursion(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:147

Parameters

Parameter	Type
operator	BidirectionalRecursion

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitBidirectionalRecursion

Inherited from

CalculationBuilder.visitBidirectionalRecursion

---

visitCalculation()

visitCalculation(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:113

Parameters

Parameter	Type
operator	Calculation

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitCalculation

Inherited from

CalculationBuilder.visitCalculation

---

visitCartesianProduct()

visitCartesianProduct(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:126

Parameters

Parameter	Type
operator	CartesianProduct

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitCartesianProduct

Inherited from

CalculationBuilder.visitCartesianProduct

---

visitConditional()

visitConditional(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:116

Parameters

Parameter	Type
operator	Conditional

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitConditional

Inherited from

CalculationBuilder.visitConditional

---

visitDifference()

visitDifference(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:137

Parameters

Parameter	Type
operator	Difference

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitDifference

Inherited from

CalculationBuilder.visitDifference

---

visitDistinct()

visitDistinct(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:138

Parameters

Parameter	Type
operator	Distinct

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitDistinct

Inherited from

CalculationBuilder.visitDistinct

---

visitFnCall()

visitFnCall(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:111

Parameters

Parameter	Type
operator	FnCall

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitFnCall

Inherited from

CalculationBuilder.visitFnCall

---

visitGroupBy()

visitGroupBy(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:133

Parameters

Parameter	Type
operator	GroupBy

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitGroupBy

Inherited from

CalculationBuilder.visitGroupBy

---

visitIndexedRecursion()

visitIndexedRecursion(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:146

Parameters

Parameter	Type
operator	IndexedRecursion

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitIndexedRecursion

Inherited from

CalculationBuilder.visitIndexedRecursion

---

visitIndexScan()

visitIndexScan(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:145

Parameters

Parameter	Type
operator	IndexScan

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitIndexScan

Inherited from

CalculationBuilder.visitIndexScan

---

visitIntersection()

visitIntersection(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:136

Parameters

Parameter	Type
operator	Intersection

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitIntersection

Inherited from

CalculationBuilder.visitIntersection

---

visitItemFnSource()

visitItemFnSource(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:141

Parameters

Parameter	Type
operator	ItemFnSource

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitItemFnSource

Inherited from

CalculationBuilder.visitItemFnSource

---

visitItemSource()

visitItemSource(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:92

Parameters

Parameter	Type
operator	ItemSource

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitItemSource

Inherited from

CalculationBuilder.visitItemSource

---

visitJoin()

visitJoin(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:127

Parameters

Parameter	Type
operator	Join

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitJoin

Inherited from

CalculationBuilder.visitJoin

---

visitLangSwitch()

visitLangSwitch(operator): CalculationParams

Defined in: lang-sql/src/visitors/calculation-builder.ts:18

Parameters

Parameter	Type
operator	LangSwitch

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitLangSwitch

---

visitLimit()

visitLimit(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:134

Parameters

Parameter	Type
operator	Limit

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitLimit

Inherited from

CalculationBuilder.visitLimit

---

visitLiteral()

visitLiteral(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:112

Parameters

Parameter	Type
operator	Literal<unknown>

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitLiteral

Inherited from

CalculationBuilder.visitLiteral

---

visitMapFromItem()

visitMapFromItem(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:130

Parameters

Parameter	Type
operator	MapFromItem

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitMapFromItem

Inherited from

CalculationBuilder.visitMapFromItem

---

visitMapToItem()

visitMapToItem(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:129

Parameters

Parameter	Type
operator	MapToItem

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitMapToItem

Inherited from

CalculationBuilder.visitMapToItem

---

visitNullSource()

visitNullSource(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:139

Parameters

Parameter	Type
operator	NullSource

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitNullSource

Inherited from

CalculationBuilder.visitNullSource

---

visitOrderBy()

visitOrderBy(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:132

Parameters

Parameter	Type
operator	OrderBy

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitOrderBy

Inherited from

CalculationBuilder.visitOrderBy

---

visitProjection()

visitProjection(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:89

Parameters

Parameter	Type
operator	Projection

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitProjection

Inherited from

CalculationBuilder.visitProjection

---

visitProjectionConcat()

visitProjectionConcat(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:128

Parameters

Parameter	Type
operator	ProjectionConcat

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitProjectionConcat

Inherited from

CalculationBuilder.visitProjectionConcat

---

visitProjectionIndex()

visitProjectionIndex(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:131

Parameters

Parameter	Type
operator	ProjectionIndex

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitProjectionIndex

Inherited from

CalculationBuilder.visitProjectionIndex

---

visitQuantifier()

visitQuantifier(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:143

Parameters

Parameter	Type
operator	Quantifier

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitQuantifier

Inherited from

CalculationBuilder.visitQuantifier

---

visitRecursion()

visitRecursion(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:144

Parameters

Parameter	Type
operator	Recursion

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitRecursion

Inherited from

CalculationBuilder.visitRecursion

---

visitSelection()

visitSelection(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:90

Parameters

Parameter	Type
operator	Selection

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitSelection

Inherited from

CalculationBuilder.visitSelection

---

visitTableAlias()

visitTableAlias(operator, arg?): CalculationParams

Defined in: lang-sql/src/visitors/calculation-builder.ts:32

Parameters

Parameter	Type
operator	TableAlias
arg?	never

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitTableAlias

---

visitTupleFnSource()

visitTupleFnSource(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:142

Parameters

Parameter	Type
operator	TupleFnSource

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitTupleFnSource

Inherited from

CalculationBuilder.visitTupleFnSource

---

visitTupleSource()

visitTupleSource(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:91

Parameters

Parameter	Type
operator	TupleSource

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitTupleSource

Inherited from

CalculationBuilder.visitTupleSource

---

visitUnion()

visitUnion(operator): CalculationParams

Defined in: core/dist/visitors/calculation-builder.d.ts:135

Parameters

Parameter	Type
operator	Union

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitUnion

Inherited from

CalculationBuilder.visitUnion

---

visitUsing()

visitUsing(operator): CalculationParams

Defined in: lang-sql/src/visitors/calculation-builder.ts:25

Parameters

Parameter	Type
operator	Using

Returns

CalculationParams

Implementation of

SQLPlanVisitor.visitUsing