There’s a big range between sober and drunk. The key to work drinks/happy hour is go for a single drink and leave. You get the best parts of being social and avoid the vast majority of the issues that come from people drinking with colleagues.