Struct QueryBuilder 

pub struct QueryBuilder { /* private fields */ }

Fluent SQL query builder.

Example

use oxisql_parse::QueryBuilder;

let sql = QueryBuilder::select(&["id", "name", "email"])
    .from("users")
    .join("orders", "users.id = orders.user_id")
    .where_clause("users.active = TRUE")
    .where_clause("orders.status = 'pending'")
    .order_by("users.name", true)
    .limit(10)
    .offset(20)
    .build()
    .expect("valid query");
assert!(sql.contains("SELECT id, name, email"));

Implementations

impl QueryBuilder

pub fn select(columns: &[&str]) -> Self

Start a SELECT query with the given columns.

pub fn select_all() -> Self

Start a SELECT * query.

pub fn distinct(self) -> Self

Add DISTINCT to the SELECT clause.

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

Set the FROM table.

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

Add an INNER JOIN.

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

Add a LEFT JOIN.

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

Add a RIGHT JOIN.

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

Add a WHERE condition. Multiple calls are combined with AND.

pub fn group_by(self, expr: &str) -> Self

Add a GROUP BY expression.

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

Set the HAVING clause.

pub fn order_by(self, expr: &str, ascending: bool) -> Self

Add an ORDER BY expression. ascending = true → ASC, false → DESC.

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

Set LIMIT.

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

Set OFFSET.

pub fn build(self) -> Result<String, String>

Build the final SQL string.

Returns Err if no FROM table has been set.

pub fn build_and_parse(self) -> Result<Vec<Statement>, String>

Build and immediately parse the SQL to verify it is syntactically valid.

Returns Err if building fails or if the resulting SQL cannot be parsed.

pub fn build_ref(&self) -> Result<String, String>

Build the SQL string without consuming self.

Internally clones the builder fields and delegates to Self::build. Prefer build when the builder is no longer needed.

pub fn insert(table: &str, columns: &[&str], values: &[&str]) -> String

Build an INSERT INTO … VALUES (…) statement.

Example

use oxisql_parse::QueryBuilder;

let sql = QueryBuilder::insert("users", &["id", "name"], &["1", "'Alice'"]);
assert_eq!(sql, "INSERT INTO users (id, name) VALUES (1, 'Alice')");

pub fn update( table: &str, sets: &[(&str, &str)], where_clause: Option<&str>, ) -> String

Build an UPDATE … SET … [WHERE …] statement.

Example

use oxisql_parse::QueryBuilder;

let sql = QueryBuilder::update(
    "users",
    &[("name", "'Bob'"), ("active", "FALSE")],
    Some("id = 42"),
);
assert!(sql.starts_with("UPDATE users SET"));
assert!(sql.contains("WHERE id = 42"));

pub fn delete(table: &str, where_clause: Option<&str>) -> String

Build a DELETE FROM … [WHERE …] statement.

Example

use oxisql_parse::QueryBuilder;

let sql = QueryBuilder::delete("users", Some("id = 99"));
assert_eq!(sql, "DELETE FROM users WHERE id = 99");