Result Sets

let set = conn.execute("SELECT id, name FROM t ORDER BY id")?.materialize()?;

assert!(!set.is_empty());
for row in set.rows() {                 // &[DuckRow]
    let _ = row.get("id");
}
let first = set.first();                // Option<&DuckRow>
let n = set.len();
let changed = set.changes();            // affected-row count for DML; 0 for SELECT

// Send + Sync + Clone — move it to another thread:
let moved = set.clone();
let counted = std::thread::spawn(move || moved.len()).join().unwrap();

use better_duck_core::FromRow;

#[derive(FromRow, Debug)]
struct Task { id: i32, name: String, done: Option<bool> }

let tasks: Vec<Task> = conn
    .execute("SELECT id, name, done FROM tasks")?
    .materialize()?
    .to_structs()?;