The following query parses ok:
SELECT JSON_OBJECTAGG( KEY foo VALUE bar) FROM dual
But this one doesn't (only change is adding prefixes to column names:
SELECT JSON_OBJECTAGG( KEY q.foo VALUE q.bar) FROM dual
Also, this alternative is valid but fail parsing:
SELECT JSON_OBJECTAGG(foo, bar) FROM dual
The following query parses ok:
SELECT JSON_OBJECTAGG( KEY foo VALUE bar) FROM dualBut this one doesn't (only change is adding prefixes to column names:
SELECT JSON_OBJECTAGG( KEY q.foo VALUE q.bar) FROM dualAlso, this alternative is valid but fail parsing:
SELECT JSON_OBJECTAGG(foo, bar) FROM dual