The query
SELECT * from iaq returns the following series from my measurement
name: iaq
time value
---- -----
1661017870699402874 {"temp":21.5,"hum":35}
1661017895506436376 device=esp8266-14a,sensor=bme680 temp=30.1,hum=74.5
1661017897036520403 device=esp8266-14a,sensor=bme680 temp=30.1,hum=74.5
1661017900531543305 device=esp8266-14a,sensor=bme680 temp=30.1,hum=74.5
But when I run SELECT temp,hum,device FROM iaq
nothing is returned. I am writing a string to the database using the influx line protocol from an esp-8266 using the Arduino framework. How do I extract the temp and hum data from device=esp8266-14a?