[teiid-issues] [JBoss JIRA] (TEIID-5481) Evaluate JSONPATH as expression language for Json payload to table

[ https://issues.jboss.org/browse/TEIID-5481?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5481: --------------------------------------- After some additional consideration jsoncast is probably not initially needed - pg does not offer direct cast of json to non-string types either. Shown in the pr is a form of json parsing that converts to a multi-dimensional array for processing by arraytable: {code} select * from arraytable(rows jsontoarray(jsonValue, '$..book[0:2]', false, '@.author', '@.title', '@.price') columns author string, title string, price decimal) as x {code} This side steps the issue of introducing additional parsing constructs and a reflective interface for contributing a RelationalNode. Alternatively I could introduce a more formal definition of a record/row set table function extension, or just go ahead and introduce some additional parsing logic, which would simplify this example to: {code} select * from jsontable(jsonValue, '$..book[0:2]', false columns author string, title string, price decimal) as x {code} -- This message was sent by Atlassian Jira (v7.12.1#712002)