Diesel Backend Overview

[dependencies]
better-duck-diesel = "0.1.0-beta.8"
diesel = "2.3"

use better_duck_diesel::DuckDbConnection;
use diesel::prelude::*;

diesel::table! {
    products (id) {
        id    -> Integer,
        name  -> Text,
        price -> Double,
    }
}

fn main() -> Result<(), Box<dyn std::error::Error>> {
    // `:memory:` or a file path; a leading `duckdb://` is stripped.
    let mut conn = DuckDbConnection::establish(":memory:")?;
    conn.batch_execute(
        "CREATE TABLE products (id INTEGER PRIMARY KEY, name VARCHAR NOT NULL, price DOUBLE NOT NULL)",
    )?;

    diesel::insert_into(products::table)
        .values((products::id.eq(1), products::name.eq("widget"), products::price.eq(9.99)))
        .execute(&mut conn)?;

    let rows: Vec<(i32, String, f64)> = products::table
        .filter(products::price.lt(20.0))
        .order(products::name.asc())
        .load(&mut conn)?;
    assert_eq!(rows, [(1, "widget".to_string(), 9.99)]);
    Ok(())
}

use diesel::prelude::*;
use better_duck_diesel::dsl::*;