There's some data on scholar, for instance a suggested health difference between wine vs beers or spirits, based on ~28k participants monitored over 2-19 years[0].
From my understanding the narrative of moderate alcohol consumption (specifically wine, via resveritrol) being beneficial comes from epidemiological studies of people living in the Mediterranean, an area with relatively long median life spans[1]