Struct QueryBuilder

pub struct QueryBuilder { /* private fields */ }

Query builder for SELECT operations

Implementations

impl QueryBuilder

pub fn select(self, columns: &str) -> Self

Select specific columns

pub fn eq(self, column: &str, value: &str) -> Self

Add an equality filter

pub fn neq(self, column: &str, value: &str) -> Self

Add a not equal filter

pub fn gt(self, column: &str, value: &str) -> Self

Add a greater than filter

pub fn gte(self, column: &str, value: &str) -> Self

Add a greater than or equal filter

pub fn lt(self, column: &str, value: &str) -> Self

Add a less than filter

pub fn lte(self, column: &str, value: &str) -> Self

Add a less than or equal filter

pub fn like(self, column: &str, pattern: &str) -> Self

Add a LIKE filter

pub fn ilike(self, column: &str, pattern: &str) -> Self

Add an ILIKE filter (case-insensitive)

pub fn is(self, column: &str, value: &str) -> Self

Add an IS filter (for null checks)

pub fn in(self, column: &str, values: &[&str]) -> Self

Add an IN filter

pub fn order(self, column: &str, direction: OrderDirection) -> Self

Add ordering

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

Set limit

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

Set offset

pub fn single(self) -> Self

Return single row

pub async fn execute<T>(&self) -> Result<Vec<T>>

where T: for<'de> Deserialize<'de>,

Execute the query

pub async fn single_execute<T>(&self) -> Result<Option<T>>

where T: for<'de> Deserialize<'de>,

Execute the query and return a single row

Trait Implementations

impl Clone for QueryBuilder

fn clone(&self) -> QueryBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for QueryBuilder

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

Formats the value using the given formatter.