Function stripCommentsAndStrings

src/utils/sql-parser.ts:204–231

(sql: string, dialect?: ConnectorType)

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

  while (i < sql.length) {
    const token = scanToken(sql, i);

    if (token.type === TokenType.Plain) {
      if (plainStart === -1) { plainStart = i; }
    } else {
      if (plainStart !== -1) {
        parts.push(sql.substring(plainStart, i));
        plainStart = -1;
      }
      parts.push(" ");
    }

    i = token.end;
  }

  if (plainStart !== -1) {
    parts.push(sql.substring(plainStart));
  }

  return parts.join("");
}

/**
 * Split SQL into individual statements, handling semicolons inside quoted contexts.