Struct SqlBuilder 

pub struct SqlBuilder { /* private fields */ }

Builds parameterized SQL queries safely.

All user-supplied values go through DuckDB’s parameter binding (? placeholders), never through string interpolation. Methods return &mut Self for chaining.

Implementations

impl SqlBuilder

pub fn new(table: &str) -> Self

Create a builder targeting the given table or view.

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

Set the columns to select (replaces the default *).

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

Add DISTINCT to the SELECT clause.

pub fn join(&mut self, clause: &str) -> &mut Self

Add a JOIN clause.

The clause should be a full JOIN expression, e.g. "JOIN sets s ON cards.setCode = s.code".

pub fn where_clause(&mut self, condition: &str, params: &[&str]) -> &mut Self

Add a WHERE condition with ? placeholders for each param.

The caller provides a condition using ? for each parameter value. Parameters are appended in order.

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

Add a case-insensitive LIKE condition.

Generates: LOWER({column}) LIKE LOWER(?)

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

Add an IN condition with parameterized values.

Empty values list produces FALSE.

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

Add an equality condition: {column} = ?.

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

Add a greater-than-or-equal condition: {column} >= ?.

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

Add a less-than-or-equal condition: {column} <= ?.

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

Add a regex match condition using DuckDB’s regexp_matches.

Generates: regexp_matches({column}, ?)

pub fn where_fuzzy( &mut self, column: &str, value: &str, threshold: f64, ) -> &mut Self

Add a fuzzy string match condition using Jaro-Winkler similarity.

Generates: jaro_winkler_similarity({column}, ?) > {threshold}

The threshold must be between 0.0 and 1.0 (inclusive).

pub fn where_or(&mut self, conditions: &[(&str, &str)]) -> &mut Self

Add OR-combined conditions.

Each condition is a (sql_fragment, param_value) tuple where the fragment uses ? as a placeholder.

Example

use mtgjson_sdk::SqlBuilder;
let mut builder = SqlBuilder::new("cards");
builder.where_or(&[("name = ?", "Bolt"), ("name = ?", "Counter")]);
// -> WHERE (name = ? OR name = ?)

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

Add GROUP BY columns.

pub fn having(&mut self, condition: &str, params: &[&str]) -> &mut Self

Add a HAVING condition with ? placeholders.

pub fn order_by(&mut self, clauses: &[&str]) -> &mut Self

Add ORDER BY clauses (e.g. "name ASC", "price DESC").

pub fn limit(&mut self, n: usize) -> &mut Self

Set the maximum number of rows to return.

pub fn offset(&mut self, n: usize) -> &mut Self

Set the number of rows to skip before returning results.

pub fn build(&self) -> (String, Vec<String>)

Build the final SQL string and parameter list.

Returns a tuple of (sql_string, params_list) ready for execution.