I don't use python on a regular basis... but did you forget the 'select' part of the command?
select = '(select PAAuditRuleResultView.BenchmarkID PAAuditRuleResultView.RuleID PAXRuleTextView.Title)'
Yep that is exactly what it was apparently I had been looking at code too long yesterday and totally overlooked that. Found it this morning upon coming in. Thankks for the help