Function splitSQLStatements

src/utils/sql-parser.ts:237–260

(sql: string, dialect?: ConnectorType)

 * When no dialect is specified, only ANSI SQL syntax is recognized.
 */
export function splitSQLStatements(sql: string, dialect?: ConnectorType): string[] {
  const scanToken = getScanner(dialect);
  const statements: string[] = [];
  let stmtStart = 0;
  let i = 0;

  while (i < sql.length) {
    if (sql[i] === ";") {
      const trimmed = sql.substring(stmtStart, i).trim();
      if (trimmed.length > 0) { statements.push(trimmed); }
      stmtStart = i + 1;
      i++;
      continue;
    }

    const token = scanToken(sql, i);
    i = token.end;
  }

  const trimmed = sql.substring(stmtStart).trim();
  if (trimmed.length > 0) { statements.push(trimmed); }

  return statements;
}