Skip to main content

Subquery

Struct Subquery 

Source
pub struct Subquery {
    pub this: Expression,
    pub alias: Option<Identifier>,
    pub column_aliases: Vec<Identifier>,
    pub order_by: Option<OrderBy>,
    pub limit: Option<Limit>,
    pub offset: Option<Offset>,
    pub distribute_by: Option<DistributeBy>,
    pub sort_by: Option<SortBy>,
    pub cluster_by: Option<ClusterBy>,
    pub lateral: bool,
    pub modifiers_inside: bool,
    pub trailing_comments: Vec<String>,
}
Expand description

Represent a parenthesized subquery expression.

A subquery wraps an inner query (typically a SELECT, UNION, etc.) in parentheses and optionally applies an alias, column aliases, ORDER BY, LIMIT, and OFFSET. The modifiers_inside flag controls whether the modifiers are rendered inside or outside the parentheses.

Subqueries appear in many SQL contexts: FROM clauses, WHERE IN/EXISTS, scalar subqueries in select-lists, and derived tables.

Fields§

§this: Expression

The inner query expression.

§alias: Option<Identifier>

Optional alias for the derived table.

§column_aliases: Vec<Identifier>

Optional column aliases: AS t(c1, c2)

§order_by: Option<OrderBy>

ORDER BY clause (for parenthesized queries)

§limit: Option<Limit>

LIMIT clause

§offset: Option<Offset>

OFFSET clause

§distribute_by: Option<DistributeBy>

DISTRIBUTE BY clause (Hive/Spark)

§sort_by: Option<SortBy>

SORT BY clause (Hive/Spark)

§cluster_by: Option<ClusterBy>

CLUSTER BY clause (Hive/Spark)

§lateral: bool

Whether this is a LATERAL subquery (can reference earlier tables in FROM)

§modifiers_inside: bool

Whether modifiers (ORDER BY, LIMIT, OFFSET) should be generated inside the parentheses true: (SELECT 1 LIMIT 1) - modifiers inside false: (SELECT 1) LIMIT 1 - modifiers outside

§trailing_comments: Vec<String>

Trailing comments after the closing paren

Trait Implementations§

Source§

impl Clone for Subquery

Source§

fn clone(&self) -> Subquery

Returns a duplicate 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 Subquery

Source§

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

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

impl<'de> Deserialize<'de> for Subquery

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 PartialEq for Subquery

Source§

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

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 StructuralPartialEq for Subquery

Auto Trait Implementations§

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, 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>,