We have this awesome session param (default to false don't know why :( ). @steveburnett - can you fix row to json cast documentation to talk about this session param. It will basically preserve the row field named as json field names. This part:

SELECT CAST(CAST(ROW(123, 'abc', true) AS ROW(v1 BIGINT, v2 VARCHAR, v3 BOOLEAN)) AS JSON); -- JSON '[123,"abc",true]'

in json.html. Add one more line about this session param and it will show field names like this: