SUM + IN in sqlx

Cargo.toml

[package]
name = "sqlxxx"
version = "0.1.0"
edition = "2021"

[dependencies]
anyhow = "1.0.86"
sqlx = { version = "0.7", features = ["runtime-tokio", "tls-rustls", "sqlite"] }
tokio = { version = "1", features = ["macros", "rt-multi-thread"] }

main.rs

use sqlx::sqlite::SqlitePool;
use sqlx::QueryBuilder;
use std::env;

#[derive(sqlx::FromRow)]
struct SumResult {
    sum: Option<i64>
}

#[tokio::main(flavor = "current_thread")]
async fn main() -> anyhow::Result<()> {
    let ids = vec![1,2,3,4];
    let pool = SqlitePool::connect(&env::var("DATABASE_URL")?).await?;
    let mut conn = pool.acquire().await?;

    let mut query = QueryBuilder::new(
        "SELECT SUM(n) as sum FROM alfa WHERE id IN (");
    let mut separated = query.separated(", ");
    for id in ids.iter() {
        separated.push_bind(id);
    }
    let q = query.push(")").build_query_as::<SumResult>();

    let r = q.fetch_one(&mut *conn).await?;

    println!("{:?}", r.sum);
    
    Ok(())
}