Method hasLimitClause

src/utils/sql-row-limiter.ts:20–26

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

(sql: string)

   * Strips comments and string literals first to avoid false positives.
   */
  static hasLimitClause(sql: string): boolean {
    // Strip comments and strings to avoid matching LIMIT inside them
    const cleanedSQL = stripCommentsAndStrings(sql);
    // Detect LIMIT clause - handles literal numbers and parameter placeholders ($1, ?, @p1)
    const limitRegex = /\blimit\s+(?:\d+|\$\d+|\?|@p\d+)/i;
    return limitRegex.test(cleanedSQL);
  }

  /**
   * Check if a SQL statement already has a TOP clause (SQL Server).