Interface SelectCore

One SELECT … FROM … WHERE … block.

interface SelectCore {
    Distinct: DistinctClause | null;
    Fetch: FetchClause | null;
    For: ForClause | null;
    From: FromClause | null;
    GroupBy: GroupByClause | null;
    Having: ConditionClause | null;
    Into: IntoClause | null;
    Kind: "Select";
    Limit: LimitClause | null;
    Offset: OffsetClause | null;
    Option: OptionClause | null;
    OrderBy: OrderByClause | null;
    Qualify: ConditionClause | null;
    SelectList: readonly SelectItem[];
    SelectListSpan: Span;
    Span: Span;
    Top: TopClause | null;
    Unrecognized: readonly UnknownNode[];
    Where: ConditionClause | null;
    Window: WindowClause | null;
}

Hierarchy (View Summary)

QueryTailClauses
- SelectCore

Index

Properties

Distinct Fetch For From GroupBy Having Into Kind Limit Offset Option OrderBy Qualify SelectList SelectListSpan Span Top Unrecognized Where Window

Properties

`Readonly`Distinct

Distinct: DistinctClause | null

`Readonly`Fetch

Fetch: FetchClause | null

`Readonly`For

For: ForClause | null

`Readonly`From

From: FromClause | null

`Readonly`GroupBy

GroupBy: GroupByClause | null

`Readonly`Having

Having: ConditionClause | null

`Readonly`Into

Into: IntoClause | null

`Readonly`Kind

Kind: "Select"

`Readonly`Limit

Limit: LimitClause | null

`Readonly`Offset

Offset: OffsetClause | null

`Readonly`Option

Option: OptionClause | null

`Readonly`OrderBy

OrderBy: OrderByClause | null

`Readonly`Qualify

Qualify: ConditionClause | null

QUALIFY condition (Snowflake, Databricks).

`Readonly`SelectList

SelectList: readonly SelectItem[]

`Readonly`SelectListSpan

SelectListSpan: Span

The select list's extent, from its first item to its last.

`Readonly`Span

Span: Span

`Readonly`Top

Top: TopClause | null

`Readonly`Unrecognized

Unrecognized: readonly UnknownNode[]

Clauses inside the block that could not be read.

`Readonly`Where

Where: ConditionClause | null

`Readonly`Window

Window: WindowClause | null