Wiktionary
piss-artist
n. 1 (context chiefly British English) a drunkard 2 (context chiefly British English) someone who pretends to be knowledgeable on some subject
Usage examples of "piss-artist".
Adam Arnie damnyou didn't I tell you I'd handle this on my own get out and call off those piss-artist commandos!