SQL features¶
Stub
Final content will be a single scannable table: every SQL feature with supported? and notes columns, and each "no" row linked to the matching validation error.
Planned coverage:
| Feature | Supported? | Notes |
|---|---|---|
SELECT columns / expressions |
✅ | |
WHERE (conjunctive, disjunctive) |
✅ | |
GROUP BY / HAVING |
✅ | |
ORDER BY / LIMIT / OFFSET |
✅ | Top-K is pushed to partitions. |
INNER JOIN (ordinary, a.x = b.x) |
✅ | |
LEFT JOIN (ordinary or XMATCH) |
✅ | |
RIGHT JOIN / FULL JOIN / CROSS JOIN |
❌ | |
JOIN ... ON XMATCH(...) |
✅ | Must be the entire ON predicate. |
XMATCH_DISTANCE(<alias>) in SELECT/WHERE/ORDER BY |
✅ | Arcseconds. |
XMATCH(r => ..., mode => 'all') |
✅ | |
IN_MOC(<alias>, '<name>') in WHERE conjunction |
✅ | |
IN_MOC(...) in SELECT / ORDER BY / CASE |
✅ | |
IN_MOC(...) inside OR |
❌ | Rejected. |
IN_MOC(...) in JOIN ON |
❌ | Rejected. |
COUNT, SUM, AVG, MIN, MAX |
✅ | Decomposable; phase-1 partials. |
MEDIAN, MODE, STRING_AGG, window funcs |
❌ | Rejected. |
DISTINCT, COUNT(DISTINCT) |
✅ | Falls back to full materialization. |
CTEs (WITH ...) |
❌ | |
| Subqueries in the anchor position | ❌ | |
CASE WHEN ... THEN ... END |
✅ |