Struct PivotColumn 

pub struct PivotColumn<X: Extension = NoExt> {
    pub expr: Expr<X>,
    pub values: ThinVec<PivotExpr<X>>,
    pub enum_source: Option<Ident>,
    pub value_source: Option<Box<PivotValueSource<X>>>,
    pub meta: Meta,
}

One pivot column and its optional IN source — a statement ON entry (year, year IN (2000, 2010), year IN (SELECT …)) or a table-factor FOR head (FOR <col> IN (<values>), FOR <col> IN <enum>, FOR <col> IN (ANY [ORDER BY …]), FOR <col> IN (<subquery>)).

The value source is spread across three mutually-exclusive fields rather than one enum: values (the explicit list) and enum_source are DuckDB’s native shapes and stay untouched, while value_source carries the standard ANY/subquery forms added for the Snowflake/BigQuery/Oracle table factor. This deliberately deviates from sqlparser-rs’s single PivotValueSource { List, Any, Subquery } enum: that shape lives at the whole-pivot level and cannot express DuckDB’s per-column FOR y IN (…) m IN (…) heads or its IN <enum> form, so this node keeps the source per column and folds the two new forms into an Option beside the existing DuckDB fields (see PivotValueSource). Exactly one of the three is populated for any one column.

Fields

expr: Expr<X>

The pivoted column or expression (a grouped (a, b) reads as a row expression). A statement entry whose IN source is a subquery keeps the whole Expr::InSubquery here — the engine admits it (probed on 1.5.4) and the subquery is a value source, not a value list.

values: ThinVec<PivotExpr<X>>

The explicit IN (<values>) list; empty for a statement ON column whose values DuckDB auto-detects at bind time (and whenever enum_source or value_source carries the IN instead).

enum_source: Option<Ident>

The table factor’s IN <enum> form (FOR m IN month_enum): the values come from a named ENUM type rather than a written list. A single unqualified name — the engine rejects a qualified one (probed on 1.5.4) — and mutually exclusive with values.

value_source: Option<Box<PivotValueSource<X>>>

The standard PIVOT’s non-list value sources — IN (ANY [ORDER BY …]) and IN (<subquery>) (Snowflake/BigQuery/Oracle), gated on TableFactorSyntax::pivot_value_sources. None for the explicit-list, enum, and auto-detected DuckDB forms; mutually exclusive with values/enum_source. Boxed to keep the common (list) column small while the source is wide.

meta: Meta

Source location and node identity.

Trait Implementations

impl<X: Clone + Extension> Clone for PivotColumn<X>

fn clone(&self) -> PivotColumn<X>

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<X: Debug + Extension> Debug for PivotColumn<X>

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

Formats the value using the given formatter.

impl<'de, X> Deserialize<'de> for PivotColumn<X>

where X: Deserialize<'de> + Extension,

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl<X: Eq + Extension> Eq for PivotColumn<X>

impl<X: Hash + Extension> Hash for PivotColumn<X>

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl<X: PartialEq + Extension> PartialEq for PivotColumn<X>

fn eq(&self, other: &PivotColumn<X>) -> bool

Equality operator ==.

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

Inequality operator !=.

impl<X: Extension + Render> Render for PivotColumn<X>

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

Return the render for this value.

fn operand_binding_power(&self) -> Option<BindingPower>

The binding power this node contributes when it appears as an operand, or None (the default) for a self-delimiting node — an atom, call, or constructor — that never needs parentheses.

impl<X> Serialize for PivotColumn<X>

where X: Serialize + Extension,

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl<X: Extension> Spanned for PivotColumn<X>

fn span(&self) -> Span

Return the span for this value.

impl<X: PartialEq + Extension> StructuralPartialEq for PivotColumn<X>