Feature Request: Support multiple SQL statements in single Exec() call

[jnesss]

Currently, when executing multiple SQL statements (particularly CREATE TABLE statements) in a single Exec() call, Limbo only executes the first statement and ignores the rest.

// This code only creates table1, ignoring table2 and table3
schema := `
CREATE TABLE table1 (id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE table2 (id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE table3 (id INTEGER PRIMARY KEY, name TEXT);
`
_, err = db.Exec(schema)

The same CREATE TABLE sequence works fine with each statement executed separately.

statements := []string{
    "CREATE TABLE table1 (id INTEGER PRIMARY KEY, name TEXT);",
    "CREATE TABLE table2 (id INTEGER PRIMARY KEY, name TEXT);",
    "CREATE TABLE table3 (id INTEGER PRIMARY KEY, name TEXT);",
}

for _, stmt := range statements {
    _, err = db.Exec(stmt)
    // handle error
}

If this is by design (possibly for security reasons), it's fine to close this of course. Supporting multiple statements would improve compatibility with existing SQLite-based applications migrating to Limbo.

main_go.txt

[pedrocarlo]

Does something like this satisfy you? https://docs.rs/rusqlite/latest/rusqlite/struct.Connection.html#method.execute_batch.

[jnesss]

Yes, that would be great!

I've been working on the Go adapter and would be happy to add FfiDbExecuteBatch in the Go adapter after it is exposed by core. I would also be happy to propose a PR to core, of course, but I just discovered limbo two days ago, so maybe I should limit my changes to just the go adapter for now lol