sql-builder

Simple SQL code generator.

Usage

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

toml [dependencies] sql-builder = "0.11"

Example:

```rust use sql_builder::SqlBuilder;

let sql = SqlBuilder::selectfrom("company") .field("id") .field("name") .andwhere_gt("salary", 25000) .sql()?;

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

```rust use sql_builder::prelude::*;

let sql = SqlBuilder::selectfrom("company") .fields(&["id", "name"]) .andwhere("salary BETWEEN ? AND ?".binds(&[&10000, &25000])) .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

SQL support

Statements

• SELECT
• INSERT
• UPDATE
• DELETE

Operations

• join
• distinct
• group by
• order by
• where
• union
• limit, offset
• subquery

Functions

• escape
• quote, double quote, back quote
• bind, binds

License

This project is licensed under the MIT license.