pub struct Query {
pub with: Option<With>,
pub body: Box<SetExpr>,
pub order_by: Vec<OrderByExpr>,
pub limit: Option<Expr>,
pub limit_by: Vec<Expr>,
pub offset: Option<Offset>,
pub fetch: Option<Fetch>,
pub locks: Vec<LockClause>,
pub for_clause: Option<ForClause>,
}
Expand description
The most complete variant of a SELECT
query expression, optionally
including WITH
, UNION
/ other set operations, and ORDER BY
.
Fields§
§with: Option<With>
WITH (common table expressions, or CTEs)
body: Box<SetExpr>
SELECT or UNION / EXCEPT / INTERSECT
order_by: Vec<OrderByExpr>
ORDER BY
limit: Option<Expr>
LIMIT { <N> | ALL }
limit_by: Vec<Expr>
LIMIT { <N> } BY { <expr>,<expr>,... } }
offset: Option<Offset>
OFFSET <N> [ { ROW | ROWS } ]
fetch: Option<Fetch>
FETCH { FIRST | NEXT } <N> [ PERCENT ] { ROW | ROWS } | { ONLY | WITH TIES }
locks: Vec<LockClause>
FOR { UPDATE | SHARE } [ OF table_name ] [ SKIP LOCKED | NOWAIT ]
for_clause: Option<ForClause>
FOR XML { RAW | AUTO | EXPLICIT | PATH } [ , ELEMENTS ]
FOR JSON { AUTO | PATH } [ , INCLUDE_NULL_VALUES ]
(MSSQL-specific)
Trait Implementations§
source§impl Ord for Query
impl Ord for Query
source§impl PartialEq for Query
impl PartialEq for Query
source§impl PartialOrd for Query
impl PartialOrd for Query
1.0.0 · source§fn le(&self, other: &Rhs) -> bool
fn le(&self, other: &Rhs) -> bool
This method tests less than or equal to (for
self
and other
) and is used by the <=
operator. Read moresource§impl VisitMut for Query
impl VisitMut for Query
fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>where
V: VisitorMut,
impl Eq for Query
impl StructuralPartialEq for Query
Auto Trait Implementations§
impl Freeze for Query
impl RefUnwindSafe for Query
impl Send for Query
impl Sync for Query
impl Unpin for Query
impl UnwindSafe for Query
Blanket Implementations§
source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
source§impl<Q, K> Comparable<K> for Q
impl<Q, K> Comparable<K> for Q
source§impl<Q, K> Equivalent<K> for Q
impl<Q, K> Equivalent<K> for Q
source§impl<Q, K> Equivalent<K> for Q
impl<Q, K> Equivalent<K> for Q
source§fn equivalent(&self, key: &K) -> bool
fn equivalent(&self, key: &K) -> bool
Compare self to
key
and return true
if they are equal.source§impl<T> Instrument for T
impl<T> Instrument for T
source§fn instrument(self, span: Span) -> Instrumented<Self>
fn instrument(self, span: Span) -> Instrumented<Self>
source§fn in_current_span(self) -> Instrumented<Self>
fn in_current_span(self) -> Instrumented<Self>
source§impl<T> IntoEither for T
impl<T> IntoEither for T
source§fn into_either(self, into_left: bool) -> Either<Self, Self>
fn into_either(self, into_left: bool) -> Either<Self, Self>
Converts
self
into a Left
variant of Either<Self, Self>
if into_left
is true
.
Converts self
into a Right
variant of Either<Self, Self>
otherwise. Read moresource§fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
Converts
self
into a Left
variant of Either<Self, Self>
if into_left(&self)
returns true
.
Converts self
into a Right
variant of Either<Self, Self>
otherwise. Read moreCreates a shared type from an unshared type.