Struct SelectDyn 

pub struct SelectDyn<Cols, From> { /* private fields */ }

A dynamic SELECT statement builder using string-based column names.

For compile-time validated queries, use Select from builder::typed.

Uses the typestate pattern to ensure that:

• build() is only available when both columns and FROM are specified
• where_clause() is only available after FROM is specified
• group_by(), having(), order_by() follow SQL semantics

Implementations

impl SelectDyn<NoColumns, NoFrom>

pub fn new() -> Self

Creates a new SELECT builder.

impl<From> SelectDyn<NoColumns, From>

pub fn columns(self, cols: &[&str]) -> SelectDyn<HasColumns, From>

Specifies the columns to select.

pub fn all(self) -> SelectDyn<HasColumns, From>

Selects all columns (*).

impl<Cols> SelectDyn<Cols, NoFrom>

pub fn from(self, table: &str) -> SelectDyn<Cols, HasFrom>

Specifies the table to select from.

impl<Cols> SelectDyn<Cols, HasFrom>

pub fn where_clause(self, expr: ExprBuilder) -> Self

Adds a WHERE clause.

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

Adds an INNER JOIN.

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

Adds a LEFT JOIN.

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

Adds a RIGHT JOIN.

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

Adds a CROSS JOIN.

impl<From> SelectDyn<HasColumns, From>

pub fn distinct(self) -> Self

Sets DISTINCT.

impl SelectDyn<HasColumns, HasFrom>

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

Adds a GROUP BY clause.

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

Adds a HAVING clause (only valid after GROUP BY).

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

Adds an ORDER BY clause.

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

Adds an ORDER BY DESC clause.

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

Adds a LIMIT clause.

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

Adds an OFFSET clause.

pub fn build(self) -> (String, Vec<SqlValue>)

Builds the SELECT statement and returns SQL with parameters.

pub fn build_sql(self) -> String

Builds the SELECT statement and returns only the SQL string.

Warning: Parameters are inlined using proper escaping. Prefer build() for parameterized queries.

Trait Implementations

impl Default for SelectDyn<NoColumns, NoFrom>

fn default() -> Self

Returns the “default value” for a type.