Excecute only runs the first statement

Consider the following code

import { createClient } from "@libsql/client";

const file_name = process.cwd() + "/test.db";
const db_url = "file:" + file_name;

const db_client = createClient({
  url: db_url,
});

const rs = await db_client.execute(
  "CREATE TABLE a(a1 integer); CREATE TABLE b(b1 integer);"
);
console.log(rs);

Only the table a is created. The second create statement is silently ignored.

This is different from what better-sqlite3 does.
Supporting multiple statements would be useful for
reading sql statements form a file as in the example at

https://github.com/WiseLibs/better-sqlite3/blob/master/docs/api.md#execstring---this

const migration = fs.readFileSync('migrate-schema.sql', 'utf8');
db.exec(migration);

Start at the db_client.execute entry point shown in the issue and compare its behavior with the linked better-sqlite3 exec example. Done means a single input containing both CREATE statements creates both tables and supports the requested SQL-file migration use case.