Parses a compact source pattern expression.
Supported forms:
ORDER BY
LEFT [OUTER] JOIN
FETCH {FIRST|NEXT} [ROW|ROWS]