Struct Select

pub struct Select {

    pub select_token: AttachedToken,
    pub distinct: Option<Distinct>,
    pub top: Option<Top>,
    pub top_before_distinct: bool,
    pub projection: Vec<SelectItem>,
    pub into: Option<SelectInto>,
    pub from: Vec<TableWithJoins>,
    pub lateral_views: Vec<LateralView>,
    pub prewhere: Option<Expr>,
    pub selection: Option<Expr>,
    pub group_by: GroupByExpr,
    pub cluster_by: Vec<Expr>,
    pub distribute_by: Vec<Expr>,
    pub sort_by: Vec<Expr>,
    pub having: Option<Expr>,
    pub named_window: Vec<NamedWindowDefinition>,
    pub qualify: Option<Expr>,
    pub window_before_qualify: bool,
    pub value_table_mode: Option<ValueTableMode>,
    pub connect_by: Option<ConnectBy>,
}

A restricted variant of SELECT (without CTEs/ORDER BY), which may appear either as the only body item of a Query, or as an operand to a set operation like UNION.

Fields

select_token: AttachedToken

Token for the SELECT keyword

distinct: Option<Distinct>

SELECT [DISTINCT] ...

top: Option<Top>

MSSQL syntax: TOP (<N>) [ PERCENT ] [ WITH TIES ]

top_before_distinct: bool

Whether the top was located before ALL/DISTINCT

projection: Vec<SelectItem>

projection expressions

into: Option<SelectInto>

INTO

from: Vec<TableWithJoins>

FROM

lateral_views: Vec<LateralView>

LATERAL VIEWs

prewhere: Option<Expr>

ClickHouse syntax: PREWHERE a = 1 WHERE b = 2, and it can be used together with WHERE selection.

ClickHouse

selection: Option<Expr>

WHERE

group_by: GroupByExpr

GROUP BY

cluster_by: Vec<Expr>

CLUSTER BY (Hive)

distribute_by: Vec<Expr>

DISTRIBUTE BY (Hive)

sort_by: Vec<Expr>

SORT BY (Hive)

having: Option<Expr>

HAVING

named_window: Vec<NamedWindowDefinition>

WINDOW AS

qualify: Option<Expr>

QUALIFY (Snowflake)

window_before_qualify: bool

The positioning of QUALIFY and WINDOW clauses differ between dialects. e.g. BigQuery requires that WINDOW comes after QUALIFY, while DUCKDB accepts WINDOW before QUALIFY. We accept either positioning and flag the accepted variant.

value_table_mode: Option<ValueTableMode>

BigQuery syntax: SELECT AS VALUE | SELECT AS STRUCT

connect_by: Option<ConnectBy>

STARTING WITH .. CONNECT BY

Trait Implementations

impl Clone for Select

fn clone(&self) -> Select

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Select

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

Formats the value using the given formatter.

impl Display for Select

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

Formats the value using the given formatter.

impl Hash for Select

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

where __H: Hasher,

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 Select

fn cmp(&self, other: &Select) -> 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.

impl PartialEq for Select

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

fn partial_cmp(&self, other: &Select) -> 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 Spanned for Select

fn span(&self) -> Span

Return the Span (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl Visit for Select

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

where V: Visitor,

impl VisitMut for Select

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

where V: VisitorMut,

impl Eq for Select

impl StructuralPartialEq for Select