Function addPaginationToQuery

frontend/src/lib/duckdb/utils.ts:37–47

(sql: string, limit: number, offset: number)

 * @returns Modified SQL query with pagination added
 */
export function addPaginationToQuery(sql: string, limit: number, offset: number): string {
  const cleanedSQL = cleanSqlQuery(sql);
  const noSemicolon = cleanedSQL.replace(';', '');
  
  // Only add LIMIT if not already present
  if (!noSemicolon.toUpperCase().includes("LIMIT")) {
    return `${noSemicolon} LIMIT ${limit} OFFSET ${offset}`;
  }
  
  return sql;
}

/**
 * Creates a COUNT query to get the total number of rows for a SELECT query