said to mean that although a remark or proposal seems, initially, welcome or pleasing, it contains an unpleasant part at the end
The agreement had a sting in the tail. It said that the entire aid package would be suspended if the country did not make progress on the economic front.