Class PostgresQueryCompiler

a QueryCompiler compiles a query expressed as a tree of OperationNodes into SQL.

Hierarchy (view full)

Constructors

constructor

Properties

#private #private nodeStack visitNode

Accessors

numParameters parentNode

Methods

addParameter announcesNewColumnDataType append appendImmediateValue appendValue compileColumnAlterations compileDistinctOn compileList compileQuery compileUnwrappedIdentifier getAutoIncrement getCurrentParameterPlaceholder getExplainOptionAssignment getExplainOptionsDelimiter getLeftExplainOptionsWrapper getLeftIdentifierWrapper getRightExplainOptionsWrapper getRightIdentifierWrapper getSql isMinusOperator sanitizeIdentifier sortSelectModifiers visitAddColumn visitAddConstraint visitAddIndex visitAggregateFunction visitAlias visitAlterColumn visitAlterTable visitAnd visitBinaryOperation visitCase visitCast visitCheckConstraint visitColumn visitColumnDefinition visitColumnUpdate visitCommonTableExpression visitCommonTableExpressionName visitCreateIndex visitCreateSchema visitCreateTable visitCreateType visitCreateView visitDataType visitDefaultInsertValue visitDefaultValue visitDeleteQuery visitDropColumn visitDropConstraint visitDropIndex visitDropSchema visitDropTable visitDropType visitDropView visitExplain visitFetch visitForeignKeyConstraint visitFrom visitFunction visitGenerated visitGroupBy visitGroupByItem visitHaving visitIdentifier visitInsertQuery visitJSONOperatorChain visitJSONPath visitJSONPathLeg visitJSONReference visitJoin visitLimit visitList visitMatched visitMergeQuery visitModifyColumn visitOffset visitOn visitOnConflict visitOnDuplicateKey visitOperator visitOr visitOrderBy visitOrderByItem visitOver visitParens visitPartitionBy visitPartitionByItem visitPrimaryKeyConstraint visitPrimitiveValueList visitRaw visitReference visitReferences visitRenameColumn visitReturning visitSchemableIdentifier visitSelectAll visitSelectModifier visitSelectQuery visitSelection visitSetOperation visitTable visitTop visitTuple visitUnaryOperation visitUniqueConstraint visitUpdateQuery visitUsing visitValue visitValueList visitValues visitWhen visitWhere visitWith

Constructors

constructor

Properties

Private #private

#private: any

Private #private

#private: any

Protected Readonly nodeStack

nodeStack: OperationNode[]

Protected Readonly visitNode

visitNode: ((node) => void)

Type declaration

Accessors

Protected numParameters

  • get numParameters(): number

  • Returns number

Protected parentNode

  • get parentNode(): undefined | OperationNode

  • Returns undefined | OperationNode

Methods

Protected addParameter

  • addParameter(parameter): void

  • Parameters

    • parameter: unknown

    Returns void

Protected announcesNewColumnDataType

  • announcesNewColumnDataType(): boolean

  • controls whether the dialect adds a "type" keyword before a column's new data type in an ALTER TABLE statement.

    Returns boolean

Protected append

  • append(str): void

  • Parameters

    • str: string

    Returns void

Protected appendImmediateValue

  • appendImmediateValue(value): void

  • Parameters

    • value: unknown

    Returns void

Protected appendValue

  • appendValue(parameter): void

  • Parameters

    • parameter: unknown

    Returns void

Protected compileColumnAlterations

Protected compileDistinctOn

  • compileDistinctOn(expressions): void

  • Parameters

    Returns void

Protected compileList

  • compileList(nodes, separator?): void

  • Parameters

    Returns void

compileQuery

Protected compileUnwrappedIdentifier

Protected getAutoIncrement

  • getAutoIncrement(): string

  • Returns string

Protected getCurrentParameterPlaceholder

  • getCurrentParameterPlaceholder(): string

  • Returns string

Protected getExplainOptionAssignment

  • getExplainOptionAssignment(): string

  • Returns string

Protected getExplainOptionsDelimiter

  • getExplainOptionsDelimiter(): string

  • Returns string

Protected getLeftExplainOptionsWrapper

  • getLeftExplainOptionsWrapper(): string

  • Returns string

Protected getLeftIdentifierWrapper

  • getLeftIdentifierWrapper(): string

  • Returns string

Protected getRightExplainOptionsWrapper

  • getRightExplainOptionsWrapper(): string

  • Returns string

Protected getRightIdentifierWrapper

  • getRightIdentifierWrapper(): string

  • Returns string

Protected getSql

  • getSql(): string

  • Returns string

Protected isMinusOperator

Protected sanitizeIdentifier

  • sanitizeIdentifier(identifier): string

  • Parameters

    • identifier: string

    Returns string

Protected sortSelectModifiers

  • sortSelectModifiers(arr): readonly SelectModifierNode[]

  • Parameters

    • arr: SelectModifierNode[]

    Returns readonly SelectModifierNode[]

Protected visitAddColumn

Protected visitAddConstraint

Protected visitAddIndex

  • visitAddIndex(node): void

  • Parameters

    • node: AddIndexNode

    Returns void

Protected visitAggregateFunction

Protected visitAlias

  • visitAlias(node): void

  • Parameters

    Returns void

Protected visitAlterColumn

Protected visitAlterTable

Protected visitAnd

  • visitAnd(node): void

  • Parameters

    Returns void

Protected visitBinaryOperation

Protected visitCase

  • visitCase(node): void

  • Parameters

    Returns void

Protected visitCast

  • visitCast(node): void

  • Parameters

    • node: CastNode

    Returns void

Protected visitCheckConstraint

Protected visitColumn

  • visitColumn(node): void

  • Parameters

    Returns void

Protected visitColumnDefinition

Protected visitColumnUpdate

Protected visitCommonTableExpression

Protected visitCommonTableExpressionName

Protected visitCreateIndex

Protected visitCreateSchema

Protected visitCreateTable

Protected visitCreateType

Protected visitCreateView

Protected visitDataType

Protected visitDefaultInsertValue

Protected visitDefaultValue

Protected visitDeleteQuery

Protected visitDropColumn

Protected visitDropConstraint

Protected visitDropIndex

Protected visitDropSchema

Protected visitDropTable

Protected visitDropType

Protected visitDropView

Protected visitExplain

  • visitExplain(node): void

  • Parameters

    Returns void

Protected visitFetch

  • visitFetch(node): void

  • Parameters

    Returns void

Protected visitForeignKeyConstraint

Protected visitFrom

  • visitFrom(node): void

  • Parameters

    Returns void

Protected visitFunction

  • visitFunction(node): void

  • Parameters

    • node: FunctionNode

    Returns void

Protected visitGenerated

Protected visitGroupBy

  • visitGroupBy(node): void

  • Parameters

    Returns void

Protected visitGroupByItem

Protected visitHaving

  • visitHaving(node): void

  • Parameters

    Returns void

Protected visitIdentifier

Protected visitInsertQuery

Protected visitJSONOperatorChain

Protected visitJSONPath

Protected visitJSONPathLeg

Protected visitJSONReference

Protected visitJoin

  • visitJoin(node): void

  • Parameters

    Returns void

Protected visitLimit

  • visitLimit(node): void

  • Parameters

    Returns void

Protected visitList

  • visitList(node): void

  • Parameters

    Returns void

Protected visitMatched

  • visitMatched(node): void

  • Parameters

    Returns void

Protected visitMergeQuery

Protected visitModifyColumn

Protected visitOffset

  • visitOffset(node): void

  • Parameters

    Returns void

Protected visitOn

  • visitOn(node): void

  • Parameters

    Returns void

Protected visitOnConflict

Protected visitOnDuplicateKey

Protected visitOperator

Protected visitOr

  • visitOr(node): void

  • Parameters

    Returns void

Protected visitOrderBy

  • visitOrderBy(node): void

  • Parameters

    Returns void

Protected visitOrderByItem

Protected visitOver

  • visitOver(node): void

  • Parameters

    Returns void

Protected visitParens

  • visitParens(node): void

  • Parameters

    Returns void

Protected visitPartitionBy

Protected visitPartitionByItem

Protected visitPrimaryKeyConstraint

Protected visitPrimitiveValueList

Protected visitRaw

  • visitRaw(node): void

  • Parameters

    Returns void

Protected visitReference

Protected visitReferences

Protected visitRenameColumn

Protected visitReturning

Protected visitSchemableIdentifier

  • visitSchemableIdentifier(node): void

  • Parameters

    • node: SchemableIdentifierNode

    Returns void

Protected visitSelectAll

Protected visitSelectModifier

  • visitSelectModifier(node): void

  • Parameters

    • node: SelectModifierNode

    Returns void

Protected visitSelectQuery

Protected visitSelection

Protected visitSetOperation

Protected visitTable

  • visitTable(node): void

  • Parameters

    Returns void

Protected visitTop

  • visitTop(node): void

  • Parameters

    Returns void

Protected visitTuple

  • visitTuple(node): void

  • Parameters

    Returns void

Protected visitUnaryOperation

Protected visitUniqueConstraint

Protected visitUpdateQuery

Protected visitUsing

  • visitUsing(node): void

  • Parameters

    Returns void

Protected visitValue

  • visitValue(node): void

  • Parameters

    Returns void

Protected visitValueList

Protected visitValues

  • visitValues(node): void

  • Parameters

    Returns void

Protected visitWhen

  • visitWhen(node): void

  • Parameters

    Returns void

Protected visitWhere

  • visitWhere(node): void

  • Parameters

    Returns void

Protected visitWith

  • visitWith(node): void

  • Parameters

    Returns void

Settings

Member Visibility

Theme

On This Page

constructor#private#privatenodeStackvisitNodenumParametersparentNodeaddParameterannouncesNewColumnDataTypeappendappendImmediateValueappendValuecompileColumnAlterationscompileDistinctOncompileListcompileQuerycompileUnwrappedIdentifiergetAutoIncrementgetCurrentParameterPlaceholdergetExplainOptionAssignmentgetExplainOptionsDelimitergetLeftExplainOptionsWrappergetLeftIdentifierWrappergetRightExplainOptionsWrappergetRightIdentifierWrappergetSqlisMinusOperatorsanitizeIdentifiersortSelectModifiersvisitAddColumnvisitAddConstraintvisitAddIndexvisitAggregateFunctionvisitAliasvisitAlterColumnvisitAlterTablevisitAndvisitBinaryOperationvisitCasevisitCastvisitCheckConstraintvisitColumnvisitColumnDefinitionvisitColumnUpdatevisitCommonTableExpressionvisitCommonTableExpressionNamevisitCreateIndexvisitCreateSchemavisitCreateTablevisitCreateTypevisitCreateViewvisitDataTypevisitDefaultInsertValuevisitDefaultValuevisitDeleteQueryvisitDropColumnvisitDropConstraintvisitDropIndexvisitDropSchemavisitDropTablevisitDropTypevisitDropViewvisitExplainvisitFetchvisitForeignKeyConstraintvisitFromvisitFunctionvisitGeneratedvisitGroupByvisitGroupByItemvisitHavingvisitIdentifiervisitInsertQueryvisitJSONOperatorChainvisitJSONPathvisitJSONPathLegvisitJSONReferencevisitJoinvisitLimitvisitListvisitMatchedvisitMergeQueryvisitModifyColumnvisitOffsetvisitOnvisitOnConflictvisitOnDuplicateKeyvisitOperatorvisitOrvisitOrderByvisitOrderByItemvisitOvervisitParensvisitPartitionByvisitPartitionByItemvisitPrimaryKeyConstraintvisitPrimitiveValueListvisitRawvisitReferencevisitReferencesvisitRenameColumnvisitReturningvisitSchemableIdentifiervisitSelectAllvisitSelectModifiervisitSelectQueryvisitSelectionvisitSetOperationvisitTablevisitTopvisitTuplevisitUnaryOperationvisitUniqueConstraintvisitUpdateQueryvisitUsingvisitValuevisitValueListvisitValuesvisitWhenvisitWherevisitWith