Struct SelectStatement 

pub struct SelectStatement {

    pub ctes: Vec<Cte>,
    pub distinct: bool,
    pub top: Option<Box<Expr>>,
    pub columns: Vec<SelectItem>,
    pub from: Option<FromClause>,
    pub joins: Vec<JoinClause>,
    pub where_clause: Option<Expr>,
    pub group_by: Vec<Expr>,
    pub having: Option<Expr>,
    pub order_by: Vec<OrderByItem>,
    pub limit: Option<Expr>,
    pub offset: Option<Expr>,
    pub fetch_first: Option<Expr>,
    pub qualify: Option<Expr>,
    pub window_definitions: Vec<WindowDefinition>,
}

A SELECT statement, including CTEs.

Aligned with sqlglot’s Select expression which wraps With, From, Where, Group, Having, Order, Limit, Offset, Window.

Fields

ctes: Vec<Cte>

Common Table Expressions (WITH clause)

distinct: bool

top: Option<Box<Expr>>

TOP N (TSQL-style)

columns: Vec<SelectItem>

from: Option<FromClause>

joins: Vec<JoinClause>

where_clause: Option<Expr>

group_by: Vec<Expr>

having: Option<Expr>

order_by: Vec<OrderByItem>

limit: Option<Expr>

offset: Option<Expr>

fetch_first: Option<Expr>

Oracle-style FETCH FIRST n ROWS ONLY

qualify: Option<Expr>

QUALIFY clause (BigQuery, Snowflake)

window_definitions: Vec<WindowDefinition>

Named WINDOW definitions

Trait Implementations

impl Clone for SelectStatement

fn clone(&self) -> SelectStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SelectStatement

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for SelectStatement

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for SelectStatement

fn eq(&self, other: &SelectStatement) -> 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 SelectStatement

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 SelectStatement