What is sly pie?

most commonly used as the colloquial name given to those approved of by myself and friends as an otherwise 'hotty'.

this phrase is a versatile wee thing used also to describe those who are evidently actual sly pies (rare), shifty looking characters and those who are somewhat of a 'pain in the arse'.