Struct Select

Source
pub struct Select {
Show 21 fields 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>, pub flavor: SelectFlavor,
}
Expand description

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

§flavor: SelectFlavor

Was this a FROM-first query?

Trait Implementations§

Source§

impl Clone for Select

Source§

fn clone(&self) -> Select

Returns a copy of the value. Read more
1.0.0 · Source§

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

Performs copy-assignment from source. Read more
Source§

impl Debug for Select

Source§

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

Formats the value using the given formatter. Read more
Source§

impl<'de> Deserialize<'de> for Select

Source§

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>
where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer. Read more
Source§

impl Display for Select

Source§

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

Formats the value using the given formatter. Read more
Source§

impl Hash for Select

Source§

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

Feeds this value into the given Hasher. Read more
1.3.0 · Source§

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

Feeds a slice of this type into the given Hasher. Read more
Source§

impl Ord for Select

Source§

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

This method returns an Ordering between self and other. Read more
1.21.0 · Source§

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

Compares and returns the maximum of two values. Read more
1.21.0 · Source§

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

Compares and returns the minimum of two values. Read more
1.50.0 · Source§

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

Restrict a value to a certain interval. Read more
Source§

impl PartialEq for Select

Source§

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

Tests for self and other values to be equal, and is used by ==.
1.0.0 · Source§

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

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.
Source§

impl PartialOrd for Select

Source§

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

This method returns an ordering between self and other values if one exists. Read more
1.0.0 · Source§

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

Tests less than (for self and other) and is used by the < operator. Read more
1.0.0 · Source§

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

Tests less than or equal to (for self and other) and is used by the <= operator. Read more
1.0.0 · Source§

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

Tests greater than (for self and other) and is used by the > operator. Read more
1.0.0 · Source§

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

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

impl Serialize for Select

Source§

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

Serialize this value into the given Serde serializer. Read more
Source§

impl Spanned for Select

Source§

fn span(&self) -> Span

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

impl Visit for Select

Source§

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

Source§

impl VisitMut for Select

Source§

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

Source§

impl Eq for Select

Source§

impl StructuralPartialEq for Select

Auto Trait Implementations§

§

impl Freeze for Select

§

impl RefUnwindSafe for Select

§

impl Send for Select

§

impl Sync for Select

§

impl Unpin for Select

§

impl UnwindSafe for Select

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T> ToString for T
where T: Display + ?Sized,

Source§

fn to_string(&self) -> String

Converts the given value to a String. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = Infallible

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, <T as TryFrom<U>>::Error>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.
Source§

impl<T> DeserializeOwned for T
where T: for<'de> Deserialize<'de>,