Unfortunately, Query Builder does not support CTE yet.
Per your response "Unfortunately, Query Builder does not support CTE yet."
You added support for CTE's to the application, but left it out of the query builder. So, the result is even though there is support now for CTE's, you still can't fully use it.
Can you you just add the WITH statement to the query builder along with the other (SELECT, DELETE, etc....) keywords it supports?
Seems like it would be a quick, simple, change.
Hmmm...I've never used the query builder so at first I didn't even know what this request was talking about. I prefer to edit and run my queries in an SQL window (CTEs are supported very well in this type of window).
If Devart can add CTEs to query builder, that will be quite the impressive bit of programming. Since CTEs at the simplest are joining of tables, but then there are beasts such as recursive CTEs. Yeah, that will be interesting to see in a UI.
It would be appreciated if CTEs could be completely implemented in query builder, or at least the minimal suggestion proposed by KCarterSr.
At $150 (Aussie dollars aren't as strong as a couple of years ago), I see this as a premium product and so I think it's reasonable to expect full query support.