Function buildDeleteQuery

apps/sim/app/api/tools/mysql/utils.ts:106–113

(table: string, where: string)

}

export function buildDeleteQuery(table: string, where: string) {
  validateWhereClause(where)

  const sanitizedTable = sanitizeIdentifier(table)
  const query = `DELETE FROM ${sanitizedTable} WHERE ${where}`

  return { query, values: [] }
}

/**
 * Validates a WHERE clause to prevent SQL injection attacks