For example, as a sarcastic remark in the sense of "pedantic" or "know-it-all"?
No. It's usually used as a commendatory term. But it can be also used in a pejorative sense (the rule is called
PS: This is not used in a conversation, or it's an irony.