PipeOperator in sqlparser::ast

PipeOperator in sqlparser::ast - Rust

pub enum PipeOperator {
Show 18 variants    Limit {
        expr: Expr,
        offset: Option<Expr>,
    },
    Where {
        expr: Expr,
    },
    OrderBy {
        exprs: Vec<OrderByExpr>,
    },
    Select {
        exprs: Vec<SelectItem>,
    },
    Extend {
        exprs: Vec<SelectItem>,
    },
    Set {
        assignments: Vec<Assignment>,
    },
    Drop {
        columns: Vec<Ident>,
    },
    As {
        alias: Ident,
    },
    Aggregate {
        full_table_exprs: Vec<ExprWithAliasAndOrderBy>,
        group_by_expr: Vec<ExprWithAliasAndOrderBy>,
    },
    TableSample {
        sample: Box<TableSample>,
    },
    Rename {
        mappings: Vec<IdentWithAlias>,
    },
    Union {
        set_quantifier: SetQuantifier,
        queries: Vec<Query>,
    },
    Intersect {
        set_quantifier: SetQuantifier,
        queries: Vec<Query>,
    },
    Except {
        set_quantifier: SetQuantifier,
        queries: Vec<Query>,
    },
    Call {
        function: Function,
        alias: Option<Ident>,
    },
    Pivot {
        aggregate_functions: Vec<ExprWithAlias>,
        value_column: Vec<Ident>,
        value_source: PivotValueSource,
        alias: Option<Ident>,
    },
    Unpivot {
        value_column: Ident,
        name_column: Ident,
        unpivot_columns: Vec<Ident>,
        alias: Option<Ident>,
    },
    Join(Join),
}

Expand description

Fields

The expression specifying the number of rows to return.

Optional offset expression provided inline with LIMIT.

Fields

ORDER BY <expr> [ASC|DESC], ...

Fields

The ordering expressions.

Fields

The select items to produce.

Fields

Expressions defining added columns.

Fields

Assignments to apply (column = expr).

Fields

Alias to assign to the input table.

Fields

Expressions computed for each row prior to grouping.

Grouping expressions for aggregation.

Fields

Sampling clause describing the sample.

Fields

Mappings of old to new identifiers.

Fields

Set quantifier (ALL or DISTINCT).

The queries to combine with UNION.

Fields

Set quantifier for the INTERSECT operator.

The queries to intersect.

Fields

Set quantifier for the EXCEPT operator.

The queries to exclude from the input set.

Fields

The function or procedure to call which returns a table.

Optional alias for the result table.

Fields

Aggregate functions to compute during pivot.

§value_column: Vec<Ident>

Column(s) that provide the pivot values.

The source of pivot values (literal list or subquery).

Optional alias for the output.

Fields

§value_column: Ident

Output column that will receive the unpivoted value.

§name_column: Ident

Column name holding the unpivoted column name.

§unpivot_columns: Vec<Ident>

Columns to unpivot.

Optional alias for the unpivot result.