I’ve found that in 0.28 I’m limited when I use SQL Queries as it prevents me using multiple values in a filter. My solution so far has been to just use a view.
Then I realised that the customer I’m working for is one of the few who would allow me to create views on their database, so had to come up with a new solution for future use.
Answer is to use SQL Server Express with linked servers. I can then create views of the ‘proper’ database within a new database in Expess. On top of that, I then create new views based upon those.
More details here: Multiple databases in one question without a data warehouse- YES YOU CAN!