Struct PivotStatement 

pub struct PivotStatement {
    pub source: Box<TableFactor>,
    pub on: Vec<Expr>,
    pub using: Vec<ExprWithAlias>,
    pub group_by: Vec<Expr>,
}

DuckDB statement-form PIVOT: PIVOT <source> ON <expr>[, …] [USING <aggregate>[, …]] [GROUP BY <expr>[, …]]

DuckDB’s “simplified” pivot. Unlike the SQL-standard TableFactor::Pivot (FROM t PIVOT (…)), this is a query in its own right — a top-level statement, a CTAS body, or a subquery — and auto-detects the pivot values from the data rather than requiring an explicit IN (…) list. See https://duckdb.org/docs/stable/sql/statements/pivot.

Fields

source: Box<TableFactor>

The relation being pivoted (table name, table function, or subquery).

on: Vec<Expr>

ON — the column expressions whose distinct values become output columns.

using: Vec<ExprWithAlias>

USING — the aggregate expressions computed per pivoted cell. Empty when omitted (DuckDB then defaults to a COUNT).

group_by: Vec<Expr>

GROUP BY — the columns retained as rows. Empty when omitted.

Trait Implementations

impl Clone for PivotStatement

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for PivotStatement

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for PivotStatement

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for PivotStatement

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

Formats the value using the given formatter.

impl Eq for PivotStatement

impl Hash for PivotStatement

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 Ord for PivotStatement

fn cmp(&self, other: &Self) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

fn clamp_to<R>(self, range: R) -> Self

where Self: Sized, R: ClampBounds<Self>,

🔬This is a nightly-only experimental API. (clamp_to)

Restrict a value to a certain range.

impl PartialEq for PivotStatement

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

Equality operator ==.

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

Inequality operator !=.

impl PartialOrd for PivotStatement

fn partial_cmp(&self, other: &Self) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

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

Tests less than (for self and other) and is used by the < operator.

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

Tests less than or equal to (for self and other) and is used by the <= operator.

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

Tests greater than (for self and other) and is used by the > operator.

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

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Serialize for PivotStatement

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 PivotStatement

impl Visit for PivotStatement

fn visit<V: Visitor>(&self, visitor: &mut V) -> ControlFlow<V::Break>

impl VisitMut for PivotStatement

fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>