Crate sql_builder

Simple SQL code generator.

Usage

To use sql-builder, first add this to your Cargo.toml:

[dependencies]
sql-builder = "0.11"

Examples:

use sql_builder::SqlBuilder;

let sql = SqlBuilder::select_from("company")
    .field("id")
    .field("name")
    .and_where_gt("salary", 25_000)
    .sql()?;

assert_eq!("SELECT id, name FROM company WHERE salary > 25000;", &sql);

use sql_builder::prelude::*;

let sql = SqlBuilder::select_from("company")
    .fields(&["id", "name"])
    .and_where("salary BETWEEN ? AND ?".binds(&[&10_000, &25_000]))
    .and_where("staff BETWEEN ? AND ?".bind(&100).bind(&200))
    .sql()?;

assert_eq!("SELECT id, name FROM company WHERE (salary BETWEEN 10000 AND 25000) AND (staff BETWEEN 100 AND 200);", &sql);

See more examples

Modules

arg
bind
prelude

Structs

SqlBuilder

Main SQL builder

Functions

baquote	Backquote string for SQL.
dquote	Double quote string for SQL.
esc	Escape string for SQL.
quote	Quote string for SQL.