I use crate to store data collected with Telegraf. And while I got the hang of accessing the nested structures like so …
select timestamp, name, fields['U_L1_L2'] as U_L1_L2, fields['U_L2_L3'] as U_L2_L3, fields['U_L3_L1'] as U_L3_L1, from E2 where name = 'sentron';
I was wondering if there was an automated way to unpack all objects in a query. There are ca. 30 columns so it is definitely possible to write the query by hand … just curious if there is a better way.