Struct Pivot 

pub struct Pivot {
    pub this: Expression,
    pub expressions: Vec<Expression>,
    pub fields: Vec<Expression>,
    pub using: Vec<Expression>,
    pub group: Option<Box<Expression>>,
    pub unpivot: bool,
    pub into: Option<Box<Expression>>,
    pub alias: Option<Identifier>,
    pub include_nulls: Option<bool>,
    pub default_on_null: Option<Box<Expression>>,
    pub with: Option<With>,
}

PIVOT operation - supports both standard and DuckDB simplified syntax

Standard syntax (in FROM clause): table PIVOT(agg_func [AS alias], … FOR column IN (value [AS alias], …)) table UNPIVOT(value_col FOR name_col IN (col1, col2, …))

DuckDB simplified syntax (statement-level): PIVOT table ON columns [IN (…)] USING agg_func [AS alias], … [GROUP BY …] UNPIVOT table ON columns INTO NAME name_col VALUE val_col

Fields

this: Expression

Source table/expression

expressions: Vec<Expression>

For standard PIVOT: the aggregation function(s) (first is primary) For DuckDB simplified: unused (use using instead)

fields: Vec<Expression>

For standard PIVOT: the FOR…IN clause(s) as In expressions

using: Vec<Expression>

For standard: unused. For DuckDB simplified: the USING aggregation functions

group: Option<Box<Expression>>

GROUP BY clause (used in both standard inside-parens and DuckDB simplified)

unpivot: bool

Whether this is an UNPIVOT (vs PIVOT)

into: Option<Box<Expression>>

For DuckDB UNPIVOT: INTO NAME col VALUE col

alias: Option<Identifier>

Optional alias

include_nulls: Option<bool>

Include/exclude nulls (for UNPIVOT)

default_on_null: Option<Box<Expression>>

Default on null value (Snowflake)

with: Option<With>

WITH clause (CTEs)

Trait Implementations

impl Clone for Pivot

fn clone(&self) -> Pivot

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for Pivot

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Pivot

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for Pivot

fn eq(&self, other: &Pivot) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for Pivot

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for Pivot