When order by clause is used inside JSON_ARRAYAGG it does not get parsed with above mentioned parser version and details.