use different sql command separator

[masgari]

Current separator ; causes problem when using BEGIN TRANSACTION or CREATE TRIGGER, example (using sqlite3):

_boot {
    exec = <<SQL

        CREATE TABLE IF NOT EXISTS "Bucket" (
            "name" VARCHAR(255) NOT NULL PRIMARY KEY,
            "dir" VARCHAR(255) UNIQUE NOT NULL,
            "createdAt" TIMESTAMP DEFAULT CURRENT_TIMESTAMP
        );
        CREATE TRIGGER IF NOT EXISTS "trig1" 
        BEFORE INSERT ON "Bucket"
        BEGIN
            SELECT RAISE(ABORT, 'Dir can not be /dev') WHERE NEW.dir like '/dev%';
        END;
   SQL
}

It generates sql commands like these:

CREATE TRIGGER IF NOT EXISTS "trig1" 
        BEFORE INSERT ON "Bucket"
        BEGIN
            SELECT RAISE(ABORT, 'Dir can not be /dev') WHERE NEW.dir like '/dev%';

and

END;

[alash3al]

but -- will make some conflicts if you have some comments, let's think in another separator

[masgari]

agreed, something like --//-- might be better as it can't cause problem in other editors too

[alash3al]

I think it will be better if that separator become an option in the cli flags