serde_sql

serde_sql streams serde::Serialize structs directly into SQLite INSERT statements without allocating intermediate field structures. You provide a String buffer and value; the crate appends the literal value list (v1, v2, …) so you can embed it in any SQL template.

Features

Zero-copy output: serialise straight into an existing String.
Handles Option, numbers, booleans, and strings with proper escaping.
Nested structures (maps/arrays) are emitted as JSON text literals.

Quick start

[dependencies]
serde_sql = { path = ".", version = "0.1.0" }
serde = { version = "1", features = ["derive"] }
serde_json = "1"

use serde::Serialize;
use serde_sql::serialize_insert;

#[derive(Serialize)]
struct User {
    id: u64,
    name: String,
    active: bool,
}

fn main() -> Result<(), Box<dyn std::error::Error>> {
    let mut sql = String::new();
    sql.push_str("INSERT INTO users VALUES ");
    serialize_insert(
        &mut sql,
        &User {
            id: 1,
            name: "Alice".into(),
            active: true,
        },
    )?;

    assert_eq!(sql, "INSERT INTO users VALUES (1, 'Alice', 1)");
    Ok(())
}

Example

cargo run --example basic

Testing

cargo test

Documentation