pub struct Query {
    pub with: Option<With>,
    pub body: Box<SetExpr>,
    pub order_by: Option<OrderBy>,
    pub limit_clause: Option<LimitClause>,
    pub fetch: Option<Fetch>,
    pub locks: Vec<LockClause>,
    pub for_clause: Option<ForClause>,
    pub settings: Option<Vec<Setting>>,
    pub format_clause: Option<FormatClause>,
    pub pipe_operators: Vec<PipeOperator>,
}

WITH (common table expressions, or CTEs)

SELECT or UNION / EXCEPT / INTERSECT

ORDER BY

LIMIT ... OFFSET ... | LIMIT <offset>, <limit>

FETCH { FIRST | NEXT } <N> [ PERCENT ] { ROW | ROWS } | { ONLY | WITH TIES }

FOR { UPDATE | SHARE } [ OF table_name ] [ SKIP LOCKED | NOWAIT ]

FOR XML { RAW | AUTO | EXPLICIT | PATH } [ , ELEMENTS ] FOR JSON { AUTO | PATH } [ , INCLUDE_NULL_VALUES ] (MSSQL-specific)

Pipe operator