Struct ChainBuilder

pub struct ChainBuilder { /* private fields */ }

Main query builder for constructing SQL queries

This is the primary interface for building SQL queries with a fluent API. It supports all major SQL operations including SELECT, INSERT, UPDATE, DELETE, as well as complex features like JOINs, CTEs, and subqueries.

Implementations

impl ChainBuilder

pub fn new(client: Client) -> ChainBuilder

Create a new ChainBuilder with the specified client

pub fn new_mysql() -> ChainBuilder

Create a new ChainBuilder for MySQL

pub fn db(&mut self, db: &str) -> &mut ChainBuilder

Set the database name

pub fn table(&mut self, table: &str) -> &mut ChainBuilder

Set the table name

pub fn table_raw( &mut self, table: &str, val: Option<Vec<Value>>, ) -> &mut ChainBuilder

Set a raw table expression

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

Enable DISTINCT

pub fn select(&mut self, select: Select) -> &mut ChainBuilder

Add a SELECT clause

pub fn select_raw( &mut self, sql: &str, binds: Option<Vec<Value>>, ) -> &mut ChainBuilder

Add a raw SELECT expression

pub fn select_distinct(&mut self, columns: Vec<String>) -> &mut ChainBuilder

Add DISTINCT SELECT

pub fn select_count(&mut self, column: &str) -> &mut ChainBuilder

Add COUNT aggregate function

pub fn select_sum(&mut self, column: &str) -> &mut ChainBuilder

Add SUM aggregate function

pub fn select_avg(&mut self, column: &str) -> &mut ChainBuilder

Add AVG aggregate function

pub fn select_max(&mut self, column: &str) -> &mut ChainBuilder

Add MAX aggregate function

pub fn select_min(&mut self, column: &str) -> &mut ChainBuilder

Add MIN aggregate function

pub fn select_alias(&mut self, column: &str, alias: &str) -> &mut ChainBuilder

Add SELECT with alias

pub fn insert(&mut self, data: Value) -> &mut ChainBuilder

Set INSERT data

pub fn insert_many(&mut self, data: Vec<Value>) -> &mut ChainBuilder

Set INSERT multiple rows data

pub fn update(&mut self, data: Value) -> &mut ChainBuilder

Set UPDATE data

pub fn insert_ignore(&mut self, data: Value) -> &mut ChainBuilder

Add INSERT IGNORE (MySQL)

pub fn insert_or_update( &mut self, data: Value, _update_data: Value, ) -> &mut ChainBuilder

Add UPSERT (INSERT … ON DUPLICATE KEY UPDATE)

pub fn update_raw( &mut self, _sql: &str, _binds: Option<Vec<Value>>, ) -> &mut ChainBuilder

Add raw UPDATE statement

pub fn increment(&mut self, column: &str, amount: i64) -> &mut ChainBuilder

Increment a column value

pub fn decrement(&mut self, column: &str, amount: i64) -> &mut ChainBuilder

Decrement a column value

pub fn delete(&mut self) -> &mut ChainBuilder

Set DELETE operation

pub fn as_name(&mut self, name: &str) -> &mut ChainBuilder

Set table alias

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

Add a WITH clause (CTE)

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

Add a recursive WITH clause (CTE)

pub fn union(&mut self, chain_builder: ChainBuilder) -> &mut ChainBuilder

Add a UNION clause

pub fn union_all(&mut self, chain_builder: ChainBuilder) -> &mut ChainBuilder

Add a UNION ALL clause

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

Configure query parts (WHERE, JOIN, etc.)

pub fn add_raw(&mut self, sql: &str, val: Option<Vec<Value>>)

Add raw SQL

pub fn to_sql(&mut self) -> (String, Vec<Value>)

Generate SQL string and bind parameters

impl ChainBuilder

pub fn to_sqlx_query(&mut self) -> Query<'_, MySql, MySqlArguments>

pub fn to_sqlx_query_as<T>(&mut self) -> QueryAs<'_, MySql, T, MySqlArguments>

where T: for<'r> FromRow<'r, MySqlRow>,

pub async fn count( &mut self, column: &str, pool: &Pool<MySql>, ) -> Result<i64, Error>

Trait Implementations

impl Clone for ChainBuilder

fn clone(&self) -> ChainBuilder

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for ChainBuilder

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for ChainBuilder

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for ChainBuilder

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

where __S: Serializer,

Serialize this value into the given Serde serializer.