Seems like the parser only supports the use of ANY and ALL in SELECT, not WHERE.
This form seems to work:
SELECT ALL column_name(s)
FROM table_name
WHERE condition;
There's a test for it in tests/sqlparser_common.rs line: 1539
This does not supported:
SELECT column_name(s)
FROM table_name
WHERE column_name operator ALL
(SELECT column_name
FROM table_name
WHERE condition);
I'm not sure why this is the case. Please let me know if this is intentional. If not I can create a PR.