feature: SELECT: col alias FROM: subquery, alias WHERE : <, >, =, <>, AND, OR, NESTED (1 = 1 AND (1 = 1)), IN(ids, subquery), NOT IN JOIN, LEFT JOIN: subquery, hash join, nested exp in ON - like a where ORDER BY: DESC, ASC (multiple cols) GROUP BY: multiple cols + function(max, min, avg, string_agg) + HAVING (nested exp like a where + COUNT(*)) LIMIT, OFFSET PERFOMANCE aka indexes: hash index(first exp(=) in where), bst index(first exp(<,>) in where). sqlite(eav) output in console
qqdb: