Tommy Johnson's "Canned Heat" is a particularly tragic drink song. It makes compulsive drinking sound about as much fun as it actually is. I read somewhere that he actually did have problems. I would not like to speculate about whether it was true.
A lot of drinking lines appear in countless blues songs. "If that river was whisky, I'd be a diving duck...." is just one. There are countless others.