If you mean a branded "product," you're probably cluing to the Stanley cup. The company Stanley (which has been making drinkware almost as long as hockey's trophy has been around) first sold the Quencher in 2016, a big steel vessel with a plastic lid and a straw. In 2020 it went viral on TikTok (and was dubbed the "Stanley cup"); some limited edition Quenchers have sold for over $500.
"Stanley Cup" happens to be the name of the National Hockey League's top prize, first awarded in 1893 to the Montreal Hockey Club. That trophy is named for the British politician Lord Stanley of Preston. By tradition, the team that wins the Stanley Cup is expected to drink champagne from its bowl.
If "An object is used to get at..." clues to a third object, you might be speaking of a Stanley knife, a.k.a. a box cutter. Stanley knives are made by Stanley Black & Decker, no relation to the Quencher-mongers.
As for the know-it-all, you're probably thinking of Major-General Stanley, the very model of a modern major-general.
https://www.youtube.com/watch?v=hlTisI_HSgw