I found a fix that helped me being extremely careful with white spaces any white lines at the end of the query will causes everything to fail.
But in general it is still a bit inconsistent like for example I have exact same query that works in one module but when copied over I get a table not found metadata error. The query syntax is correct, it just can be a bit frustrating getting the query to work with this module