using the rusqlite vtab in a rust app (https://blog.davidvassallo.me/?p=4083)

vtab_in_main.rs

fn main() -> Result<(), rusqlite::Error> {
    
    let db = Connection::open_in_memory()?;
    
    let module = rusqlite::vtab::eponymous_only_module::<Test>();
    db.create_module::<Test>("test", module, None)?;
    
    // normal rusqlite code from here on out...
    println!("Hello, world!");   
    let mut s = db.prepare("SELECT * FROM test WHERE id=1")?;

    let mut rows = s.query([])?;
    
    while let Some(row) = rows.next()? {
        let id: i64 = row.get(0)?;
        let name: String = row.get(1)?;
        println!("id: {}, name: {}", id, name);
    }

    let mut s = db.prepare("SELECT name FROM test WHERE id > 2")?;

    let mut rows = s.query([])?;
    
    while let Some(row) = rows.next()? {
        let name: String = row.get(0)?;
        println!("name: {}", name);
    }
    
    Ok(())
}