For the Trappiste monks at monasteries like Orval (in Belgium), they did brew a special beer that was just for the consumption of the monks. But it was still alcoholic, just lower in alcohol. Low enough that you would be likely to get full before you get drunk.

I've heard the same for many historical wineries.