Struct SelectBuilder 

pub struct SelectBuilder { /* private fields */ }

Builder for SELECT queries.

Implementations

impl SelectBuilder

pub fn with_capacity(self, capacity: SelectCapacity) -> Self

Reserve capacity for the builder’s internal vectors.

pub fn items(self, items: Vec<SelectItem>) -> Self

Sets the select items.

pub fn item(self, item: SelectItem) -> Self

Adds a select item.

pub fn computed(self, expr: Expr, alias: impl Into<String>) -> Self

Adds a computed expression with an alias.

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

Adds a WHERE clause filter.

pub fn order_by(self, column: impl Into<String>, direction: OrderDir) -> Self

Adds an ORDER BY clause.

pub fn order_by_asc(self, column: impl Into<String>) -> Self

Adds an ORDER BY ASC clause.

pub fn order_by_desc(self, column: impl Into<String>) -> Self

Adds an ORDER BY DESC clause.

pub fn take(self, n: i32) -> Self

Sets the row count (maps to SQL LIMIT).

Pass a positive value for forward pagination. Negative values signal backward pagination to callers; the dialect renders the absolute value.

pub fn skip(self, n: u32) -> Self

Sets the row offset (maps to SQL OFFSET).

pub fn join(self, clause: JoinClause) -> Self

Adds a JOIN clause.

pub fn inner_join( self, table: impl Into<String>, on: Expr, items: Vec<SelectItem>, ) -> Self

Adds an INNER JOIN clause.

pub fn left_join( self, table: impl Into<String>, on: Expr, items: Vec<SelectItem>, ) -> Self

Adds a LEFT JOIN clause.

pub fn group_by_column(self, column: ColumnMarker) -> Self

Adds a GROUP BY clause.

pub fn group_by(self, columns: Vec<ColumnMarker>) -> Self

Adds multiple columns to the GROUP BY clause.

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

Sets the HAVING clause (post-GROUP BY filter).

pub fn order_by_expr(self, expr: Expr, direction: OrderDir) -> Self

Adds an ORDER BY clause using an arbitrary expression (e.g. an aggregate function).

pub fn distinct(self, columns: Vec<String>) -> Self

Sets the columns to deduplicate on (SELECT DISTINCT / DISTINCT ON).

• Postgres: emits SELECT DISTINCT ON (col, ...) and requires those columns to appear first in ORDER BY (callers should prepend them).
• SQLite / MySQL: emits plain SELECT DISTINCT.

pub fn build(self) -> Result<Select>

Builds the final SELECT query.

Trait Implementations

impl Clone for SelectBuilder

fn clone(&self) -> SelectBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SelectBuilder

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

Formats the value using the given formatter.