bsql — Safe SQL for Rust

If it compiles, the SQL is correct.

bsql is a proc-macro library that validates every SQL query against a real PostgreSQL instance 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.6"
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 user = bsql::query!(
    //       "SELECT id, login, active FROM users WHERE id = $id: i32"
    //   ).fetch_one(&pool).await?;
    //
    // The result struct has typed fields:
    //   user.id: i32, user.login: String, user.active: bool
    //   println!("{}: {}", user.id, user.login);

    Ok(())
}

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.

Execution methods