Hi there, I’m neck deep on my first influx implementation with InfluxDb Cloud and Node.js. Struggling to get everything working with some queries. I’d LOVE to just use plain old SQL to query the db. And I can get the query working perfectly in Data Explorer, but it seems that neither of the Node.js libraries enable SQL queries only Flux queries. The data explorer doesn’t use flux only SQL.
There is a influxdb3-client available but that doesn’t work due to a package.json issue. I’m using Vite.
So as far as I can tell, I’m locked out from SQL unless there is an undocumented way of using SQL with that library, and I’ll need to wrap my head around Flux.
Funny thing is that my data has several measures per data point, I need to return all of them, but flux seems to be returning them in a format where the points are disconnected.
Strange thing is that Flux seems to be returning data with datapoints broken up, so I’ve no way of recombining.