Request: Prepared Query Batch

[Strepto]

Nice package for Sqlite on the web! Simple design and seems to work well! Starred to see the development of this.

I'd like to see a prepared query interface, possibly with a batch method. This is to populate the database based on json from a server.
I believe sqlites prepared statements could be used to optimize inserts.

const preparedStatement = await db.prepare("INSERT INTO animals VALUES (?)");
const result = await preparedStatement.runOnce(["Goose"]); // Run a single query possibly more performant due to the preparedStatement
const result2 = preparedStatement.runBatch([["Squirrel"],["Fox"]]); // Run a batch of queries to avoid IO on the worker etc for each query.
preparedStatement.dispose();

As of v0.0.1-alpha.7 its a lot faster to batch queries by doing something like below. But this requires more calls and opens up for injections etc.

// Current Workaround 
const megaquery = animals.map(x => `INSERT INTO animals values ('${x.Id}', '${x.name}')`).join(";\n")
const result = db.query(megaquery);

If this is not planned or you want to cleanup issues feel free to close this. Thank you!

[findolor]

@Strepto Hey, thanks for creating this issue. It seems like a really useful thing to implement. However, with our schedule and the amount of issues we have in other repositories, I can't give you an exact date where we can implement this.

If you want to tackle this, feel free to do it. And I would be happy to review your work.