Parser is not handling parens in the FROM clause which is part of ANSI SQL

SELECT count (*)

FROM nation n1

 join nation n2

 on ((n1.n_name = 'Germany' AND n2.n_name = 'Cambodia') OR (n1.n_name = 'Cambodia' AND n2.n_name = 'Germany'))

 join (customer c

 join orders o

 on c.c_id = o.o_c_id AND c.c_w_id = o.o_w_id AND c.c_d_id = o.o_d_id)

 on string_to_codepoint(c.c_state)[0] = n2.n_nationkey ;

msg": "Syntax error: In line 5 >> join (customer c<< Encountered <IDENTIFIER> \"c\" at column 17. ",

 "query_from_user": "SELECT count (*)\nFROM nation n1\n join nation n2\n on ((n1.n_name = 'Germany' AND n2.n_name = 'Cambodia') OR (n1.n_name = 'Cambodia' AND n2.n_name = 'Germany'))\n join (customer c\n join orders o\n on c.c_id = o.o_c_id AND c.c_w_id = o.o_w_id AND c.c_d_id = o.o_d_id)\n on string_to_codepoint(c.c_state)[0] = n2.n_nationkey ;"