Method extractTopValue

src/utils/sql-row-limiter.ts:58–66

* Extract existing TOP value from SQL if present (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 extractTopValue(sql: string): number | null {
    // Strip comments and strings to avoid matching TOP inside them
    const cleanedSQL = stripCommentsAndStrings(sql);
    const topMatch = cleanedSQL.match(/\bselect\s+top\s+(\d+)/i);
    if (topMatch) {
      return parseInt(topMatch[1], 10);
    }
    return null;
  }

  /**
   * Add or modify LIMIT clause in a SQL statement