I can sympathize with everything you said. I do think one of the greatest solutions however is to get over alcohol. Stop thinking about it every waking second and start focusing on moving on with life. Stop looking at how many beers everybody is carrying. When at the bar, make sure to laugh with everybody else. If your life partner is having a good time- rejoice in it. And most of all, in the morning when everybody is hurting, go out for a run, thanking god with every step that you still have all of Sunday to enjoy sober.
It took me a while, but I am over alcohol. And when I get the brief crave My wife's normal and responsible partaking satisfies me.