Catholics believe alcohol is acceptable in moderation (which we would say is the biblical and traditional Christian view). We regard drunkenness as a sin. The Catechism of the Catholic Church condemns drunken excess and illegal drugs in #2290-2291:

The virtue of temperance disposes us to avoid every kind of excess: the abuse of food, alcohol, tobacco, or medicine. Those incur grave guilt who, by drunkenness or a love of speed, endanger their own and others’ safety on the road, at sea, or in the air. The use of drugs inflicts very grave damage on human health and life. Their use, except on strictly therapeutic grounds, is a grave offense. Clandestine production of and trafficking in drugs are scandalous practices. They constitute direct co-operation in evil, since they encourage people to practices gravely contrary to the moral law.

In my understanding, the notion held by some Protestants that alcohol is intrinsically evil derives primarily (if not solely) from the temperance and prohibition movements in the mid-1800s and onward. Several denominations, such as the Presbyterians and the Methodists (maybe even the Baptists?), changed at that time from serving alcohol (following the implied “wine” of the biblical description) in the Lord’s Supper / Communion, to grape juice, almost entirely on political grounds.

Lutherans and Anglicans have always used wine for Holy Communion. Neither Martin Luther (who was quite fond of wine) nor John Calvin (Institutes, 3:19:7; 4:13:9 — citing St. Augustine) opposed wine-drinking. Calvin casually assumes that wine will be used for Holy Communion (4:17:43), as it had always been used in the Church previous to that time.

Fundamentalists try to assert that the biblical “wine” is merely unfermented grape juice. The term “strong drink, ” however, in contrast to “wine,” is seen (e.g., Lev 10:9; Num 6:3; Deut 14:26; 29:6; Jud 13:4, 7, 14; 1 Sam 1:15; Prov 31:4; Mic 2:11; cf. Prov 20:1; 31:6; Is 5:11, 22; 24:9; 28:7; 56:12; Lk 1:15).

This Hebrew word is shekar, defined by Strong’s Concordance (word #7941) as “intoxicant, i.e., intensely alcoholic liquor – strong drink.” 

Note that God doesn’t outright forbid this “strong drink” as immoral in and of itself. In fact, in Deuteronomy 14:26, Moses (see Deut 1:1) says in so many words that it is perfectly acceptable to drink it.

The writer of Proverbs advises giving “strong drink” to the dying, and “wine to those in bitter distress; let them drink and forget their poverty, and remember their misery no more” (31:6-7; NRSV). This is similar to the Apostle Paul’s suggestion to “take a little wine for the sake of your stomach and your frequent ailments” (1 Tim 5:23; NRSV).

In many of these passages, it is implied, however, that excessive drinking of this intoxicant, or drunkenness, is a bad thing, characteristic of the wicked. Thus, the Bible (and the Catholic Church, following it) condemns drunkenness, but not all use of alcohol or wine (e.g., Deut 21:20; Prov 20:1; 21:17; 23:20-21, 29-35; 26:9; Is 5:11-12; Rom 13:13; 1 Cor 5:11; 6:10; Gal 5:21; 1 Tim 3:3, 8; Titus 1:7; 2:3; 1 Pet 4:3).

Many Old Testament passages praise wine (e.g., Jud 9:13; Ps 104:15). Having “plenty” of wine is a divine blessing (Gen 27:28). Wine was used at the ancient Jewish festivals (Passover, Pentecost, Tabernacles), and on the Sabbath, and was offered as a libation in Jewish rituals (Ex 29:40; 1 Sam 1:24), which may account for its later use in the Passover Seder. The Talmud called for red wine to be used. The Last Supper was a Jewish Passover (see Mt 26:17 ff.; Mk 14:12 ff.; Lk 22:15 ff.; Jn 13:1 ff.); hence Jesus undeniably used wine as the example of what was to become the Christian Eucharist.

Jesus partook of wine and was absurdly accused by his critics of being a drunkard (Matt 11:19; Lk 7:33). He turned water into wine (not grape juice), in His first miracle (Jn 2:1 ff.). Jesus drank wine on the cross:

John 19:29-30 (NRSV) A jar full of sour wine was standing there. So they put a sponge full of the wine on a branch of hyssop and held it to his mouth. When Jesus had received the wine, he said, ‘It is finished.’ Then he bowed his head and gave up his spirit. (cf. Mt 27:48; Mk 15:36)

This word, oxos in Greek, is translated as “vinegar” in the King James VersionThayer’s Greek-English Lexicon of the New Testament (4th ed., 1901, rep. by Baker Book House, Grand Rapids, Michigan, 1977) defines it (Strong’s word #3690) as follows:

. . . used in the NT for Latin ‘posca,’ i.e., the mixture of sour wine or vinegar and water which the Roman soldiers were accustomed to drink. (p. 449)

In fact, the Roman soldiers offered this drink to Jesus before the crucifixion, and he refused (Mt 27:34; Lk 23:36; Mk 15:23). But the interesting thing is that the best texts of Matthew 27:34 have the New Testament word for “wine,” oinos (Strong’s #3631), rather than oxos, thus strongly inferring that what Jesus was given on the cross was indeed wine, not vinegar.

Jesus refused this drink because it contained myrrh, which – combined with alcohol – would have had a narcotic effect. But he accepted this same drink without the myrrh on the cross, just before he died (Jn 19:29-30; cf. Mt 27:48; Mk 15:36). Some might still dispute that it was (or contained wine, with alcohol), but many modern translations render oxos at John 19:29-30; Matthew 27:48; and Mark 15:36 as “wine,” “sour wine,” or similar description. The New Testament oinos [“wine”] was a fermented drink, though probably less strong than our current wine.

Fermentation is implied, e.g., in the mention of the bursting of the wineskins (Matt 9:17; Mk 2:22; Lk 5:37). Ephesians 5:18 states that one can theoretically get “drunk with wine” and Paul commands us not to do that (cf. Jn 2:10). Wine is to be avoided if it stumbles a brother (Rom 14:21).