Struct QueryBuilder 

pub struct QueryBuilder<'d> { /* private fields */ }

Builds parameterized SQL statements for a specific dialect.

Usage

use fletch_orm::query_builder::{QueryBuilder, Order};
use fletch_orm::dialect::PostgresDialect;
use fletch_orm::filter::{Filter, Op};

let dialect = PostgresDialect;
let query = QueryBuilder::select(&dialect, "users")
    .columns(&["id", "name", "email"])
    .filter(Filter::new("name", Op::Eq, "Alice"))
    .order_by("id", Order::Asc)
    .limit(10)
    .build();

assert_eq!(
    query.sql,
    "SELECT \"id\", \"name\", \"email\" FROM \"users\" WHERE \"name\" = $1 ORDER BY \"id\" ASC LIMIT 10"
);

Implementations

impl<'d> QueryBuilder<'d>

pub fn select(dialect: &'d dyn Dialect, table: &str) -> Self

Begin a SELECT query.

pub fn insert(dialect: &'d dyn Dialect, table: &str) -> Self

Begin an INSERT query.

pub fn update(dialect: &'d dyn Dialect, table: &str) -> Self

Begin an UPDATE query.

pub fn delete(dialect: &'d dyn Dialect, table: &str) -> Self

Begin a DELETE query.

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

Set the columns to select (SELECT) or insert into (INSERT).

pub fn filter(self, f: Filter) -> Self

Add a filter condition to the WHERE clause.

pub fn order_by(self, column: &str, order: Order) -> Self

Add an ORDER BY clause.

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

Set the LIMIT.

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

Set the OFFSET.

pub fn set(self, column: &str, value: impl Into<Value>) -> Self

Set a column value for INSERT or UPDATE operations.

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

Specify columns to return via RETURNING (Postgres/SQLite). On MySQL, this is ignored; use LAST_INSERT_ID() instead.

pub fn build(self) -> BuiltQuery

Build the SQL query and return the SQL string with bind values.