Interface PivotSource

source PIVOT (…) alias / source UNPIVOT (…) alias.

interface PivotSource {
    Alias: IdentifierNode | null;
    Body: SqlExpression;
    ColumnAliases: readonly IdentifierNode[];
    Form: "Pivot" | "Unpivot";
    Kind: "Pivot";
    Source: FromSource;
    Span: Span;
}

Hierarchy (View Summary)

SourceAlias
- PivotSource

Index

Properties

Alias Body ColumnAliases Form Kind Source Span

Properties

`Readonly`Alias

Alias: IdentifierNode | null

The alias; null when none is written.

`Readonly`Body

Body: SqlExpression

The text inside the parentheses.

`Readonly`ColumnAliases

ColumnAliases: readonly IdentifierNode[]

The column aliases after the alias, x(a, b); empty when none.

`Readonly`Form

Form: "Pivot" | "Unpivot"

`Readonly`Kind

Kind: "Pivot"

`Readonly`Source

Source: FromSource

`Readonly`Span

Span: Span