SELECT/ORDER/JOINS with jQuery Query Builder?

Hello all,

Firstly, thank you very much for your hard work on this project - it has been very useful to me.

I have an issue though - when using SQL, how would one specify SELECT statements? Here's the example I'm trying to achieve:

SELECT city, airport
FROM mytable
WHERE owner = "admin"
AND (
    city = "Venice"
    OR city = "Palma"
);

My database table is, very simply, as follows:

+--------------------------------------+
| city       | owner      | airport    |
+--------------------------------------+
| ...        | ...        | ...        |
|            |            |            |
+--------------------------------------+

The query builder handles the WHERE part very well, but could it be used to express SELECTs as well? And building upon that, what about COUNT() and GROUP BY, or ORDER BY and LIMIT? Is that something that I could start doing with the query builder or would I have to write it all myself?

Thanks!

No source file, test, or entry point is named; begin by tracing the existing WHERE-building API and its documentation. The scope must first be agreed for SELECT, COUNT, GROUP BY, ORDER BY, and LIMIT, with tests defining which SQL expressions are supported.