Struct SqliteSelect 

pub struct SqliteSelect {
    pub fields: Vec<Expression<AnySqliteType>>,
    pub from: Vec<Expression<AnySqliteType>>,
    pub joins: Vec<SqliteSelectJoin>,
    pub where_conditions: Vec<Expression<AnySqliteType>>,
    pub order_by: Vec<(Expression<AnySqliteType>, Order)>,
    pub group_by: Vec<Expression<AnySqliteType>>,
    pub having: Vec<Expression<AnySqliteType>>,
    pub windows: Vec<(String, Window<AnySqliteType>)>,
    pub ctes: Vec<(String, Expression<AnySqliteType>, bool)>,
    pub distinct: bool,
    pub limit: Option<i64>,
    pub skip: Option<i64>,
}

SQLite SELECT statement builder.

Fields

fields: Vec<Expression<AnySqliteType>>

from: Vec<Expression<AnySqliteType>>

joins: Vec<SqliteSelectJoin>

where_conditions: Vec<Expression<AnySqliteType>>

order_by: Vec<(Expression<AnySqliteType>, Order)>

group_by: Vec<Expression<AnySqliteType>>

having: Vec<Expression<AnySqliteType>>

windows: Vec<(String, Window<AnySqliteType>)>

ctes: Vec<(String, Expression<AnySqliteType>, bool)>

distinct: bool

limit: Option<i64>

skip: Option<i64>

Implementations

impl SqliteSelect

pub fn as_aggregate( &self, func: &str, column: impl Expressive<AnySqliteType>, ) -> Expression<AnySqliteType>

impl SqliteSelect

pub fn render(&self) -> Expression<AnySqliteType>

pub fn preview(&self) -> String

impl SqliteSelect

pub fn new() -> Self

pub fn with_join(self, join: SqliteSelectJoin) -> Self

pub fn add_having(&mut self, condition: impl Expressive<AnySqliteType>)

pub fn with_having(self, condition: impl Expressive<AnySqliteType>) -> Self

pub fn with_window( self, name: impl Into<String>, window: Window<AnySqliteType>, ) -> Self

pub fn with_cte( self, name: impl Into<String>, query: impl Expressive<AnySqliteType>, recursive: bool, ) -> Self

Trait Implementations

impl Clone for SqliteSelect

fn clone(&self) -> SqliteSelect

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SqliteSelect

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

Formats the value using the given formatter.

impl Default for SqliteSelect

fn default() -> Self

Returns the “default value” for a type.

impl Expressive<AnySqliteType> for SqliteSelect

fn expr(&self) -> Expression<AnySqliteType>

Convert this construct into an Expression<T>.

fn preview(&self) -> String

where T: Debug + Display,

Preview the expression as a formatted string.

impl Selectable<AnySqliteType, SqliteCondition> for SqliteSelect

fn add_source( &mut self, source: impl Into<SourceRef<AnySqliteType>>, alias: Option<String>, )

Adds a data source to the FROM clause (table name, subquery, etc.). This is additive — calling it multiple times adds comma-separated sources.

fn add_field(&mut self, field: impl Into<String>)

Adds a column name to the SELECT clause.

fn add_expression(&mut self, expression: impl Expressive<AnySqliteType>)

Adds a complex expression to the SELECT clause.

fn add_where_condition(&mut self, condition: impl Into<SqliteCondition>)

Adds a condition to the WHERE clause.

fn set_distinct(&mut self, distinct: bool)

Sets whether the query should return distinct results.

fn add_order_by(&mut self, order: impl Into<SqliteCondition>, direction: Order)

Adds an ORDER BY clause with direction and optional null handling.

fn add_group_by(&mut self, expression: impl Expressive<AnySqliteType>)

Adds a GROUP BY clause.

fn set_limit(&mut self, limit: Option<i64>, skip: Option<i64>)

Sets LIMIT and OFFSET for result pagination.

fn clear_fields(&mut self)

Removes all fields from the SELECT clause.

fn clear_where_conditions(&mut self)

Removes all WHERE conditions.

fn clear_order_by(&mut self)

Removes all ORDER BY clauses.

fn clear_group_by(&mut self)

Removes all GROUP BY clauses.

fn has_fields(&self) -> bool

Returns true if any fields have been added to SELECT clause.

fn has_where_conditions(&self) -> bool

Returns true if any WHERE conditions have been added.

fn has_order_by(&self) -> bool

Returns true if any ORDER BY clauses have been added.

fn has_group_by(&self) -> bool

Returns true if any GROUP BY clauses have been added.

fn is_distinct(&self) -> bool

Returns true if DISTINCT mode is enabled.

fn get_limit(&self) -> Option<i64>

Returns the current LIMIT value, if set.

fn get_skip(&self) -> Option<i64>

Returns the current OFFSET/SKIP value, if set.

fn as_field(&self, field: impl Into<String>) -> Expression<AnySqliteType>

Creates a single-field subquery expression from this query configuration.

fn as_count(&self) -> Expression<AnySqliteType>

Creates a COUNT(*) expression from this query configuration.

fn as_sum( &self, column: impl Expressive<AnySqliteType>, ) -> Expression<AnySqliteType>

Creates a SUM(column) expression from this query configuration.

fn as_max( &self, column: impl Expressive<AnySqliteType>, ) -> Expression<AnySqliteType>

Creates a MAX(column) expression from this query configuration.

fn as_min( &self, column: impl Expressive<AnySqliteType>, ) -> Expression<AnySqliteType>

Creates a MIN(column) expression from this query configuration.

fn with_source(self, source: impl Into<SourceRef<T>>) -> Self

where Self: Sized,

Builder pattern method identical to Self::add_source without alias.

fn with_source_as( self, source: impl Into<SourceRef<T>>, alias: impl Into<String>, ) -> Self

where Self: Sized,

Builder pattern method identical to Self::add_source with alias.

fn with_condition(self, condition: impl Into<C>) -> Self

where Self: Sized,

Builder pattern method identical to Self::add_where_condition.

fn with_order(self, order: impl Into<C>, direction: Order) -> Self

where Self: Sized,

Builder pattern method identical to Self::add_order_by.

fn with_field(self, field: impl Into<String>) -> Self

where Self: Sized,

Builder pattern method identical to Self::add_field.

fn with_expression(self, expression: impl Expressive<T>) -> Self

where Self: Sized,

Builder pattern method identical to Self::add_expression.

fn with_group_by(self, expression: impl Expressive<T>) -> Self

where Self: Sized,

Builder pattern method identical to Self::add_group_by.

fn with_distinct(self, distinct: bool) -> Self

where Self: Sized,

Builder pattern method identical to Self::set_distinct.

fn with_limit(self, limit: Option<i64>, skip: Option<i64>) -> Self

where Self: Sized,

Builder pattern method identical to Self::set_limit.