That makes sense, and I can see why you're having problems.

Is it possible to get the Columns renamed in the XML source or is this a fixed definition?

One thing you could do is create a staging database with Case sensitivity enabled, preload the XML there then sit a view over the top with Proper column names.