DuckDB SQL DSL Overview

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

// standalone
let n: f64 = diesel::select(sqrt(16.0_f64)).get_result(&mut conn)?; // 4.0

// in a projection
let names: Vec<String> = products::table.select(upper(products::name)).load(&mut conn)?;

// in a predicate
let hits: Vec<i32> = products::table
    .filter(length(products::name).gt(3_i64))
    .select(products::id)
    .load(&mut conn)?;

use better_duck_diesel::dsl::*;

let m: Option<f64> = products::table.select(median(products::price)).first(&mut conn)?;

use better_duck_diesel::values::UBigInt;
use better_duck_diesel::sql_types::DuckUBigInt;
use diesel::IntoSql;

let v = UBigInt(u64::MAX);
let got: UBigInt = diesel::select(v.into_sql::<DuckUBigInt>()).get_result(&mut conn)?;