Sample SQL file (schema)

Handle it in code

Each snippet below was run against this exact file with Python 3.14.4 and Node 24.15.0 when this page was built, and the output shown is what it printed.

Python

Splitting a script on every semicolon breaks on semicolons inside strings, comments and triggers. sqlite3.complete_statement knows the grammar, so feed it lines until it says a statement is complete.

import sqlite3

statements, current = [], ""
with open("schema.sql", encoding="utf-8") as f:
    for line in f:
        current += line
        if sqlite3.complete_statement(current):
            statements.append(current.strip())
            current = ""
db = sqlite3.connect(":memory:", isolation_level=None)  # the script manages its own transaction
for s in statements:
    db.execute(s)
made = db.execute("SELECT type, name FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' ORDER BY type, name").fetchall()
print(len(statements), "statements, all executed")
print(", ".join(f"{kind} {name}" for kind, name in made))

Run against this file, it prints: 8 statements, all executed index idx_users_email, table orders, table users, view order_totals