Struct SelectStmt 

pub struct SelectStmt {
    pub distinct: bool,
    pub distinct_on: Vec<Expr>,
    pub columns: Vec<SelectColumn>,
    pub from: Option<FromClause>,
    pub joins: Vec<Join>,
    pub where_: Option<Expr>,
    pub order_by: Vec<OrderBy>,
    pub limit: Option<Expr>,
    pub offset: Option<Expr>,
}

A SELECT statement.

Fields

distinct: bool

Whether to use DISTINCT (eliminates duplicate rows).

distinct_on: Vec<Expr>

DISTINCT ON columns (PostgreSQL-specific, returns first row of each group).

columns: Vec<SelectColumn>

Columns to select (empty means SELECT *).

from: Option<FromClause>

The FROM clause specifying the primary table.

joins: Vec<Join>

JOIN clauses for related tables.

where_: Option<Expr>

The WHERE clause filter condition.

order_by: Vec<OrderBy>

ORDER BY clauses for sorting results.

limit: Option<Expr>

LIMIT clause to restrict number of rows.

offset: Option<Expr>

OFFSET clause for pagination.

Implementations

impl SelectStmt

pub fn new() -> Self

pub fn distinct(self) -> Self

Set DISTINCT to eliminate duplicate rows.

pub fn distinct_on(self, cols: impl IntoIterator<Item = Expr>) -> Self

Set DISTINCT ON columns (PostgreSQL-specific). Returns the first row of each group defined by these columns.

pub fn column(self, col: SelectColumn) -> Self

pub fn columns(self, cols: impl IntoIterator<Item = SelectColumn>) -> Self

pub fn from(self, from: FromClause) -> Self

pub fn join(self, join: Join) -> Self

pub fn where_(self, expr: Expr) -> Self

pub fn and_where(self, expr: Expr) -> Self

pub fn order_by(self, order: OrderBy) -> Self

pub fn limit(self, expr: Expr) -> Self

pub fn offset(self, expr: Expr) -> Self

Trait Implementations

impl Clone for SelectStmt

fn clone(&self) -> SelectStmt

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SelectStmt

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

Formats the value using the given formatter.

impl Default for SelectStmt

fn default() -> SelectStmt

Returns the “default value” for a type.

impl Render for SelectStmt

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