[Gambas-user] SQLRequest (Q2 of 2) Actually a couple of questions/wishes

[bb]

@Benoit

1. Could you please add a Clear() method to the class. (It would be
really handy when building complex sets of queries.) 

2. How about CTE's?
hSQLRequest.With(CTEx).Select(...
where CTEx is another SQLRequest. Now that would be super handy!

3. Joins? Yes, I recognize that one could be difficult.

4. UNION? EXCEPT? INTERSECT?

5. Calling functions or stored procedures with and without parameters?

6. Uniting a whole bunch of SQLReqests, separated by ";" for submission
to the server as a "script"?

regards
bruce