Finally managed to get over to the Yamaha dealer to see if the bit need is available. Seems not and they were not interested in fixing it in any other way e.g. a bodge.
So, off to buy a small bit of metal tube of some kind to fit in the hole and then apply shit loads of JB Weld to see if that holds it in place. It should do as it’s pretty potent stuff by all accounts.
Once set and cured it’ll be back on with the hose and see if the bastard leaks. Fingers crossed it doesn’t so I can at least part ex it for a new(ish) bike………now don’t worry, I’m not about to start a Pete-style poll!