bsql — Safe SQL for Rust

If it compiles, the SQL is correct.

bsql validates every SQL query against a real database at compile time. There is no query() function. There is no escape hatch. There is query! — validated, typed, checked. If the binary is produced, every SQL query in it is correct.

Quick Start

[dependencies]
bsql = "0.16"
tokio = { version = "1", features = ["rt-multi-thread", "macros"] }

Set the database URL for compile-time validation:

export BSQL_DATABASE_URL="postgres://user:pass@localhost/mydb"

Then:

use bsql::{Pool, BsqlError};

#[tokio::main]
async fn main() -> Result<(), BsqlError> {
    let pool = Pool::connect("postgres://user:pass@localhost/mydb").await?;

    // Every query is validated against the real database at compile time.
    // If this compiles, the SQL is correct — tables, columns, types, all checked.
    //
    //   let id = 1i32;
    //   let users = bsql::query!(
    //       "SELECT id, login, active FROM users WHERE id = $id: i32"
    //   ).fetch(&pool).await?;
    //   let user = &users[0];
    //
    // The result struct has typed fields:
    //   user.id: i32, user.login: String, user.active: bool
    //   println!("{}: {}", user.id, user.login);

    Ok(())
}

Three methods — that's it

Power users: fetch_one, fetch_optional, fetch_stream, for_each also available.

No escape hatch

There is no bsql::query() function. There is no raw_sql(). There is no way to execute unchecked SQL through bsql. If you need unchecked SQL, use tokio-postgres directly. bsql will not become the thing it replaces.