Struct WindowDefBuilder 

pub struct WindowDefBuilder { /* private fields */ }

Builder for constructing named WINDOW clause definitions.

Used with SelectBuilder::window() to define reusable window specifications. Supports PARTITION BY and ORDER BY clauses.

Examples

use polyglot_sql::builder::*;

let sql = select(["id"])
    .from("t")
    .window(
        "w",
        WindowDefBuilder::new()
            .partition_by(["dept"])
            .order_by([col("salary").desc()]),
    )
    .to_sql();

Implementations

impl WindowDefBuilder

pub fn new() -> Self

Create a new, empty window definition builder with no partitioning or ordering.

pub fn partition_by<I, E>(self, expressions: I) -> Self

where I: IntoIterator<Item = E>, E: IntoExpr,

Set the PARTITION BY expressions for the window definition.

pub fn order_by<I, E>(self, expressions: I) -> Self

where I: IntoIterator<Item = E>, E: IntoExpr,

Set the ORDER BY expressions for the window definition.

Expressions not already wrapped with .asc() or .desc() default to ascending order.