Struct lumus_sql_builder::sqlite::Select

pub struct Select { /* private fields */ }

Implementations

impl Select

pub fn new<T: Into<String>>(table: T) -> Select

Creates a new Select instance with the specified table name.

Example

use lumus_sql_builder::sqlite::Select;
Select::new("users").columns("name, age");

pub fn distinct(&mut self) -> &mut Self

Specifies that the select statement should return distinct rows.

pub fn columns<T: Into<String>>(&mut self, columns: T) -> &mut Self

Specifies the columns to be selected in the query.

pub fn group<T: Into<String>>(&mut self, group: T) -> &mut Self

Specifies the grouping for the query results.

pub fn order<T: Into<String>>(&mut self, order: T) -> &mut Self

Specifies the ordering for the query results.

pub fn limit(&mut self, limit: u32) -> &mut Self

Specifies the maximum number of rows to be returned by the query.

pub fn offset(&mut self, offset: u32) -> &mut Self

Specifies the offset for the query results.

pub fn build(&self) -> String

Builds and returns the SQL statement for the select query.

Trait Implementations

impl Display for Select

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

Formats the value using the given formatter.