Yes, it is like "sweetheart" - either tender and intimate or sarcastic. No specific limitations.