Can multiple SQL statement blocks be split into a single SQL string?

[zzliux]

Does Duckdb have a tool that can split multiple SQL statements into a single SQL statement, or can split execution be specified to obtain the execution results of each SQL statement as needed.

Similar scenes:
Use navicat to execute multiple statements at once, split them and execute them sequentially. If the data is too large, support pagination to retrieve the data is also required

[jraymakers]

I'm not sure what you mean by splitting multiple statements into a single one. There's the connection.extractStatements method, which takes a string that can contain more than one SQL statement, and returns an object containing the parsed representation of each of those statements, which can then be prepared and run. Is that what you're after?

[zzliux]

But when I used connection.extractStatements, there was an unexpected situation.

• demo code like this:

import * as duckdb from '@duckdb/node-api';

const sql = 'select 1;\nselect 2';

(async () => {
    const duckdbInstance = await duckdb.DuckDBInstance.create(':memory:');
    const db = await duckdbInstance.connect();

    const extractedStatements = await db.extractStatements(sql);

    const statementCount = extractedStatements.count;

    const readers = [];
    for (let stmtIndex = 0; stmtIndex < statementCount; stmtIndex++) {
        const prepared = await extractedStatements.prepare(stmtIndex);
        const reader = await prepared.streamAndRead();
        readers.push(reader);
    }

    // Simulate user on-demand query
    // Expected results: [[1]] and [[2]]
    // But actual results: [] and [[2]]
    // It seems that there can only be one `reader` instance

    await delay(1000);
    for (let reader of readers) {
        await reader.readUntil(2048);
        await delay(1000);

        console.log(reader.getRows());
    }
})()

function delay(ms) {
    return new Promise(resolve => setTimeout(resolve, ms));
}

version:

  "dependencies": {
    "@duckdb/node-api": "^1.3.1-alpha.23"
  }