This is a simple hint, but hopefully will be useful to some…
You might have noticed some examples where you have:
But what if you simply needed Profile.field AS another_name?
‘fields’=>array(‘Profile.field AS another_name’) … isn’t going to work, just like that.
What you need to do is escape the fields in your ‘fields’ array, like so:
(Note the backticks)