Maybe I’m misremembering, but when I was young and going to church, the priest would dip the Eucharist in the chalice with the wine/water mixture and put that on the tongue of the communion takers so they weren’t getting more than a taste. At the end, the priest would finish off what was left in the chalice. If the priest was a boozer, there’d probably be a big gulp of mostly wine in the chalice, but otherwise it was diluted with half water and there only had to be a little sip left so finishing it off was no big deal.
There was no obligation to polish off a whole wine bottle or anything, unless as I said, the priest was a boozer, which many were.
This practice, called intincture, is more prevalent among the Eastern Rites. It is specifically not permitted in the Latin Rite, (although when giving the Eucharist under both species was first re-introduced in the late 1960s, and not everyone was paying attention to the rules, it did appear in some Latin Rite parishes for a while).
I will not claim that it never occurs in a Latin Rite church, but it is not supposed to.
I have a very low opinion of AA myself, however, While I don’t believe it happens in every case, the truth is, based on my experience with an alcoholic drug abuser, for her it certainly took the slightest of slips for her to go off the deep end. Personally, I’m a paranoid type, if I had an addiction and beat it, I would never take the slightest amount of my former drug of choice. Sure some people can do it, but the fact is, If you never take another taste, you don’t have to find out the hard way the you aren’t one of the people who can handle it. My 2 cents worth.
My impression is that typically a priest who is a “recovering alcoholic” (i.e. on the wagon) will not consume any wine but will touch the chalice to his lips without drinking from it after administering himself the bread, so as not to make it obvious he’s abstaining from the cup.
I’m not Catholic, but because the prayer is for “the fruit of the vine”, either wine or nonalcoholic grape juice may be used for Kiddish. I’ve been to more than a few that only offered wine, and more than a few that only offered grape juice. In fact, I went to one that was to celebrate someone’s “sober bar mitzvah” (don’t ask) that used neither to avoid the appearance of alcohol.
To answer the question, the one recovering rabbi I knew just used grape juice. Since this is in accordance with the law, there’s no need for subterfuge or complicated diversions.