Is there any way to extract more than one fields from a json column? jsonextractscalar only allows one field at a time. So, if I do select jsonextractscala(jsonColumn, ‘field1’), jsonextractscalar(jsonColumn, ‘field2’), will it result in parsing the json document twice for each doc/row?

Parsing will probably happen twice but reading from disk will happen only once

Tried various things and figured one could do this: select jsonextractscalar(jsoncolumn, ‘$[“f1”, “f2"]’)