Struct SelectBuilder 

pub struct SelectBuilder { /* private fields */ }

Fluent builder for SELECT statements.

Examples

use sqlglot_rust::builder::select;

let query = select(&["a", "b"])
    .from("users")
    .where_clause("active = true")
    .order_by(&["created_at DESC"])
    .limit(10)
    .build();

Implementations

impl SelectBuilder

pub fn new() -> Self

Create a new empty SELECT builder.

pub fn dialect(self, dialect: Dialect) -> Self

Set the dialect for parsing string inputs.

pub fn columns(self, cols: &[&str]) -> Self

Add columns to the SELECT list from strings.

Each string is parsed as an expression.

pub fn column_expr(self, expr: Expr, alias: Option<&str>) -> Self

Add a single column expression.

pub fn all(self) -> Self

Add a wildcard (*) to the SELECT list.

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

Add a qualified wildcard (table.*) to the SELECT list.

pub fn distinct(self) -> Self

Set distinct mode.

pub fn from(self, table_name: &str) -> Self

Set the FROM clause to a table name.

pub fn from_table(self, table_ref: TableRef) -> Self

Set the FROM clause to a table reference.

pub fn from_subquery(self, query: Statement, alias: &str) -> Self

Set the FROM clause to a subquery.

pub fn join(self, table_name: &str, on: &str) -> Self

Add a JOIN clause.

pub fn left_join(self, table_name: &str, on: &str) -> Self

Add a LEFT JOIN clause.

pub fn right_join(self, table_name: &str, on: &str) -> Self

Add a RIGHT JOIN clause.

pub fn full_join(self, table_name: &str, on: &str) -> Self

Add a FULL JOIN clause.

pub fn cross_join(self, table_name: &str) -> Self

Add a CROSS JOIN clause.

pub fn join_using( self, table_name: &str, columns: &[&str], join_type: JoinType, ) -> Self

Add a JOIN with USING clause.

pub fn join_subquery( self, query: Statement, alias: &str, on: &str, join_type: JoinType, ) -> Self

Add a JOIN with a subquery.

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

Set the WHERE clause from a string.

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

Set the WHERE clause from an expression.

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

Add to the WHERE clause with AND.

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

Add to the WHERE clause with OR.

pub fn group_by(self, exprs: &[&str]) -> Self

Set the GROUP BY clause.

pub fn add_group_by(self, expr: &str) -> Self

Add a GROUP BY expression.

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

Set the HAVING clause.

pub fn order_by(self, exprs: &[&str]) -> Self

Set the ORDER BY clause.

pub fn add_order_by(self, expr: &str) -> Self

Add an ORDER BY item.

pub fn add_order_by_expr( self, expr: Expr, ascending: bool, nulls_first: Option<bool>, ) -> Self

Add an ORDER BY item with explicit direction.

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

Set the LIMIT clause.

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

Set the LIMIT clause from an expression.

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

Set the OFFSET clause.

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

Set the OFFSET clause from an expression.

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

Set TOP N (T-SQL style).

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

Set the QUALIFY clause (BigQuery, Snowflake).

pub fn build(self) -> Statement

Build the final SELECT statement.

pub fn build_select(self) -> SelectStatement

Build and return the inner SelectStatement.

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() -> Self

Returns the “default value” for a type.