Method extractLimitValue

src/utils/sql-row-limiter.ts:44–52

* Extract existing LIMIT value from SQL if present. * Strips comments and string literals first to avoid false positives.

(sql: string)

   * Strips comments and string literals first to avoid false positives.
   */
  static extractLimitValue(sql: string): number | null {
    // Strip comments and strings to avoid matching LIMIT inside them
    const cleanedSQL = stripCommentsAndStrings(sql);
    const limitMatch = cleanedSQL.match(/\blimit\s+(\d+)/i);
    if (limitMatch) {
      return parseInt(limitMatch[1], 10);
    }
    return null;
  }

  /**
   * Extract existing TOP value from SQL if present (SQL Server).