Would I be able to have nested parts within a query, such as:

(SELECT Count(DISTINCT UserIDPL, LodgeIDPL)

or use things like GROUP and HAVING in my queries?

Anyone?

Surely someone must know?

Also, if I'm paying £94 a month for these extensions, is support always going to be so slow?

Hello,
AS replied in the support ticket you opened for the same topic - the group by filter is available with the Data Formatter extension, it is not in the query builder. But instead of group by you can also nest queries and filter the second query by the value of the first one, in the server connect steps.
As for having - what exactly needs to be achieved?

Thanks Teodor - I'll try to recreate some examples I have using the DMX extensions and come back if I need any assistance.