We do studies which do measure self-reports of alcohol consumption over long duration periods (e.g. years).
In general, what most of these studies tend to say is:
A. Don't binge drink.
B. No, seriously, stop.
C. If female, there tend not to be positive effects of drinking more than one drink per day. No, don't add up all the alcohol from the week and drink it at one party.
D. If male, 2-3 drinks a day may have a positive effect. Some of that is because men tend to be bad at socializing. Some of the positive impact and lower stress is from the socializing. Drinking all this alcohol in one sitting by yourself in the dark is probably very bad for you. Get a drink or two with family or friends, especially at a meal. Drinking on an empty stomach tends to be bad for you.
E. Don't drive or operate machinery while drinking or shortly after that.
F. We told you to stop binge drinking. Seriously. Stop doing it. Especially in the basement and then passing out.
G. Stop writing code when you're drinking. No, it doesn't help.