🐛 Bug Report — Runtime APIs - Sqlite cannot handle comments

[rozenmd]

We've had numerous issues raised in wrangler2's repo about this:

• 🐛 BUG: Comments in SQL file is not supported  workers-sdk#4767
• 🐛 BUG: D1 migrations/executions with multiple statements & quote marks in comments fail obscurely on remote databases workers-sdk#4713
• 🐛 BUG: d1 execution with comment including semicolon causes SQL code did not contain a statement workers-sdk#3892

Test case:

-- Migration number: 0000    2024-01-17T19:27:05.527Z
CREATE table events (
    id INT PRIMARY KEY,
    name TEXT NOT NULL,
    url TEXT,
    description TEXT NOT NULL,
    location TEXT,
    starttime TEXT NOT NULL,
    endtime TEXT NOT NULL
)

I'll have a crack at writing tests that proves this is a problem, but I don't know enough C++ to actually fix it.

[rozenmd]

Closing as this isn't a bug in workerd