> Is this expected?
Yes, it is expected. See the invalid name example - JSON Functions · Teiid Documentation
> Or is there any other way to avoid it?
No any invalid xml name is made valid as per the docs.
Unfortunately this is just a mismatch between the xml and json worlds. We would like at some point to offer a more direct option, such as JSONTABLE, for json processing.
Thanks for the quick response!