Query is just obfuscating the SQL queries. It would be tremendously useful to allow us to use SQL syntax.
Though I am uncertain Blackbaud ever will do this as it would require them to expose their DB schema to the public. There are hints in the SQL previews.
This is not an area we will be focusing on opening up at this time; however, we are working to provide a better experience to access information more easily with Odata and the API.
Attachments Open full size