>>>Now if they would just do the same with CREATE QUERY.
>>>
>>
>>Well you have almost the same thing:
>>
>>CREATE VIEW
>
>Have you tried it? According to the docs CREATE VIEW is not available in a distributed EXE.

Sorry, I don't use views at all so I put the wrong syntax, I should have said:

CREATE SQL VIEW < myView > ; 
   AS < Select statement >