SQL wasnt using XML. I tried it with enabling XML parsing and it is working fine (as it doesnt use atom in xml, the default content type detection logic kicks in properly and does the conversion).