@Millionaireinthemaking
We was waiting to leave...
They said “get up you whale” and it was not said in a jokey way either!
Yeah, that's not lighthearted, it's a deliberate goading attempt to hurt you.
Is this "friend" longstanding, or new?
Either way, it's an inexcusable remark in any context other than this being a regular type of joshing exchange that each of you know is warmly sent & received - & is a two-way street.
From your reaction, it obviously isn't.
But is it a total one-off OP (in which case of course you are going to feel blindsided by it) or ... looking back, do they have form for put-downs?
Because you have no obligation to tolerate this remark. Accepting it without challenge will just open you up for more. And I suspect that maybe this is the culmination of small slights that you have previously brushed off, leading 'friend' to imagine they can escalate to this specific hurtful remark.
I see you left & chose not to go back. Well done. Don't waste another moment wondering if you should have - & you have no obligation to see this person again if you don't want to. Only you can decide that, based on the other qualities of the friendship. But I imagine, as you reflect on the dynamic of how things have actually been in the past with this person, that you might be re-evaluating how much, if any, time you want to spend with them in future.