Struct QueryBuilder

pub struct QueryBuilder { /* private fields */ }

Main query builder for constructing WHERE clauses and other query parts

Implementations

impl QueryBuilder

pub fn new(client: Client) -> Self

Create a new QueryBuilder for the specified client

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.

impl Default for QueryBuilder

fn default() -> Self

Returns the “default value” for a type.

impl<'de> Deserialize<'de> for QueryBuilder

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl HavingClauses for QueryBuilder

fn having(&mut self, column: &str, operator: &str, value: Value)

Add a HAVING condition

fn having_raw(&mut self, sql: &str, binds: Option<Vec<Value>>)

Add a HAVING condition with raw SQL

fn having_between(&mut self, column: &str, values: [Value; 2])

Add a HAVING BETWEEN condition

fn having_in(&mut self, column: &str, values: Vec<Value>)

Add a HAVING IN condition

fn having_not_in(&mut self, column: &str, values: Vec<Value>)

Add a HAVING NOT IN condition

impl JoinMethods for QueryBuilder

fn join(&mut self, table: &str, on: impl FnOnce(&mut JoinBuilder))

Add a JOIN clause

fn inner_join(&mut self, table: &str, on: impl FnOnce(&mut JoinBuilder))

Add an INNER JOIN clause

fn left_join(&mut self, table: &str, on: impl FnOnce(&mut JoinBuilder))

Add a LEFT JOIN clause

fn right_join(&mut self, table: &str, on: impl FnOnce(&mut JoinBuilder))

Add a RIGHT JOIN clause

fn left_outer_join(&mut self, table: &str, on: impl FnOnce(&mut JoinBuilder))

Add a LEFT OUTER JOIN clause

fn right_outer_join(&mut self, table: &str, on: impl FnOnce(&mut JoinBuilder))

Add a RIGHT OUTER JOIN clause

fn cross_join(&mut self, table: &str, on: impl FnOnce(&mut JoinBuilder))

Add a CROSS JOIN clause

fn full_outer_join(&mut self, table: &str, on: impl FnOnce(&mut JoinBuilder))

Add a FULL OUTER JOIN clause

fn join_using(&mut self, table: &str, columns: Vec<String>)

Add a JOIN USING clause

fn raw_join(&mut self, raw: &str, val: Option<Vec<Value>>)

Add a raw JOIN clause

impl QueryCommon for QueryBuilder

fn with(&mut self, alias: &str, chain_builder: ChainBuilder)

Add a WITH clause

fn with_recursive(&mut self, alias: &str, chain_builder: ChainBuilder)

Add a recursive WITH clause

fn union(&mut self, chain_builder: ChainBuilder)

Add a UNION clause

fn union_all(&mut self, chain_builder: ChainBuilder)

Add a UNION ALL clause

fn limit(&mut self, limit: usize)

Add a LIMIT clause

fn offset(&mut self, offset: usize)

Add an OFFSET clause

fn group_by(&mut self, columns: Vec<String>)

Add a GROUP BY clause

fn group_by_raw(&mut self, sql: &str, binds: Option<Vec<Value>>)

Add a raw GROUP BY clause

fn order_by(&mut self, column: &str, order: &str)

Add an ORDER BY clause

fn order_by_raw(&mut self, sql: &str, binds: Option<Vec<Value>>)

Add a raw ORDER BY clause

impl Serialize for QueryBuilder

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl WhereClauses for QueryBuilder

fn where_eq(&mut self, column: &str, value: Value)

Add an equality condition

fn where_ne(&mut self, column: &str, value: Value)

Add a not equality condition

fn where_in(&mut self, column: &str, values: Vec<Value>)

Add an IN condition

fn where_not_in(&mut self, column: &str, values: Vec<Value>)

Add a NOT IN condition

fn where_null(&mut self, column: &str)

Add an IS NULL condition

fn where_not_null(&mut self, column: &str)

Add an IS NOT NULL condition

fn where_between(&mut self, column: &str, values: [Value; 2])

Add a BETWEEN condition

fn where_not_between(&mut self, column: &str, values: [Value; 2])

Add a NOT BETWEEN condition

fn where_like(&mut self, column: &str, value: Value)

Add a LIKE condition

fn where_not_like(&mut self, column: &str, value: Value)

Add a NOT LIKE condition

fn where_gt(&mut self, column: &str, value: Value)

Add a greater than condition

fn where_gte(&mut self, column: &str, value: Value)

Add a greater than or equal condition

fn where_lt(&mut self, column: &str, value: Value)

Add a less than condition

fn where_lte(&mut self, column: &str, value: Value)

Add a less than or equal condition

fn where_subquery(&mut self, query: impl FnOnce(&mut QueryBuilder))

Add a subquery condition

fn or(&mut self) -> &mut QueryBuilder

Add an OR condition

fn where_raw(&mut self, sql: &str, binds: Option<Vec<Value>>)

Add a raw WHERE condition

fn where_ilike(&mut self, column: &str, value: Value)

Add a case-insensitive LIKE condition (ILIKE for Postgres, LOWER() for MySQL)

fn where_column(&mut self, lhs: &str, operator: &str, rhs: &str)

Add a column-to-column comparison

fn where_exists(&mut self, query: impl FnOnce(&mut ChainBuilder))

Add an EXISTS condition

fn where_not_exists(&mut self, query: impl FnOnce(&mut ChainBuilder))

Add a NOT EXISTS condition

fn where_json_contains(&mut self, column: &str, value: Value)

Add a JSON contains condition (MySQL JSON_CONTAINS)