Struct SelectBuilder 

pub struct SelectBuilder { /* private fields */ }

Fluent builder for SELECT queries.

Example

use oxisql_core::query::{SelectBuilder, SortDirection};

let q = SelectBuilder::new()
    .columns(&["id", "name", "email"])
    .from("users")
    .where_eq("active", &true)
    .order_by("name", Default::default())
    .limit(20)
    .offset(40)
    .build();

assert_eq!(q.sql, "SELECT id, name, email FROM users WHERE active = $1 ORDER BY name ASC LIMIT 20 OFFSET 40");

Implementations

impl SelectBuilder

pub fn new() -> Self

Create a new empty SELECT builder.

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

Add columns to SELECT. Call multiple times or pass a slice.

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

Set the FROM table.

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

Add a raw WHERE condition (e.g. "id > $1"). Call multiple times to AND them.

pub fn where_eq(self, col: &str, val: &dyn ToSqlValue) -> Self

Add a WHERE col = $N condition, binding the value.

pub fn order_by(self, col: &str, dir: SortDirection) -> Self

Add an ORDER BY clause.

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

Set LIMIT.

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

Set OFFSET.

pub fn build(self) -> BuiltQuery

Build the query into a BuiltQuery.

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.