Struct SelectBuilder 

pub struct SelectBuilder { /* private fields */ }

Builder for SELECT statements.

Implementations

impl SelectBuilder

pub fn new() -> Self

Create a new SELECT builder.

pub fn with_cte(self, name: &str, query: SqlFragment) -> Self

Add a CTE (WITH clause).

pub fn distinct(self) -> Self

Set DISTINCT.

pub fn column(self, name: &str) -> Self

Add a column to select.

pub fn column_as(self, name: &str, alias: &str) -> Self

Add a column with alias.

pub fn qualified_column(self, table: &str, column: &str) -> Self

Add a qualified column (table.column).

pub fn column_raw(self, sql: SqlFragment) -> Self

Add a raw SQL column expression.

pub fn all_columns(self) -> Self

Add all columns (*).

pub fn all_columns_from(self, table: &str) -> Self

Add all columns from a table (table.*).

pub fn from_table(self, qi: &QualifiedIdentifier) -> Self

Set the FROM table.

pub fn from_table_as(self, qi: &QualifiedIdentifier, alias: &str) -> Self

Set FROM with alias.

pub fn from_raw(self, sql: SqlFragment) -> Self

Set FROM from raw SQL.

pub fn inner_join(self, table: &str, condition: &str) -> Self

Add an INNER JOIN.

pub fn left_join(self, table: &str, condition: &str) -> Self

Add a LEFT JOIN.

pub fn left_join_lateral( self, subquery: SqlFragment, alias: &str, on: &str, ) -> Self

Add a LEFT JOIN LATERAL with subquery.

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

Add a WHERE clause.

pub fn where_raw(self, sql: SqlFragment) -> Self

Add a raw WHERE clause.

pub fn group_by(self, column: &str) -> Self

Add a GROUP BY column.

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

Add a HAVING clause.

pub fn order_by(self, expr: OrderExpr) -> Self

Add an ORDER BY clause.

pub fn order_by_raw(self, sql: SqlFragment) -> Self

Add ORDER BY from raw SQL.

pub fn limit(self, n: i64) -> Self

Set LIMIT.

pub fn offset(self, n: i64) -> Self

Set OFFSET.

pub fn build(self) -> SqlFragment

Build the SELECT statement.

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.

impl Default for SelectBuilder

fn default() -> SelectBuilder

Returns the “default value” for a type.