This works fine, but alternatively you could create the totals as a table in the same db: db = { const db = DuckDBClient.of({…}); await db.query(`CREATE TABLE totals AS (select b. * … )`); return db; }