single select

just as print or :nim:dump (if in mysql)

e.g. SELECT 1+1; // output 2

row select

SELECT expr

FROM tab[[AS ] alias] [tabop ..] | (SELECT …) [AS ]ALIAS[(colName, …)]

tabOp

WHERE → rows

GROUP BY column[, …]

HAVING → groups (take action after GROUP BY)

[SETOP

SELECT …

]

ORDER BY !can only used for the most outside SELECT (cannot for the nested) // following is non-std, mysql, sqlite supported LIMIT n OFFSET offset

SETOP