I've tried installing the latest (alpha) of 'Gotham', which I thought might have resolved this problem. It hasn't. I'm still seeing issues with the views being created. I tried some statements in I found in a post but they aren't working either - problems with the GROUP BY clause.
Some thinking and internet searches has led me to try fixing the view creation manually. I might as well work through it myself from scratch instead of hacking together a solution from other posts/