Spotfire Ideas Portal
Using JSON_TABLE is cumbersome, and there are no examples on how to do JSON parsing in a simple way using a transformation (can it even be done?).
As an example, Postgres has a simpler syntax allowing queries like this :
SELECT
id,
data::json->'name' as name,
data::json->'author' ->> 'last_name' as author
FROM books;