Method hasTopClause

src/utils/sql-row-limiter.ts:32–38

* Check if a SQL statement already has a TOP clause (SQL Server). * Strips comments and string literals first to avoid false positives.

(sql: string)

   * Strips comments and string literals first to avoid false positives.
   */
  static hasTopClause(sql: string): boolean {
    // Strip comments and strings to avoid matching TOP inside them
    const cleanedSQL = stripCommentsAndStrings(sql);
    // Simple regex to detect TOP clause - handles most common cases
    const topRegex = /\bselect\s+top\s+\d+/i;
    return topRegex.test(cleanedSQL);
  }

  /**
   * Extract existing LIMIT value from SQL if present.