Verbatim option for flux queries in influxdb integration

Feature Requests
1

I would like an option for a flux query specified in the queries_flux section of a custom influxdb sensor to be passed verbatim to influxdb, without being modified.

Reason being that prepending the query with range and bucket does not always create syntactically correct queries. Sometimes I just want my query to be passed as is.

Example:

The following query calculates the cumulative electricity cost for the day from two existing time series, however the integration prepends the join function with a range specifier, which is incorrect. I just want to use the query as it is written.

import "join"

usage = from(bucket: "homeassistant")
   |> range(start: today())
   |> filter(fn: (r) => r["entity_id"] == "emoncms_import" and r["_field"] == "value")
   |> window(every: 30m)
   |> integral(unit: 1h)
   |> map(fn: (r) => ({_value: r._value, _time: r._stop}))

cost = from(bucket: "homeassistant")
    |> range(start: today())
    |> filter(fn: (r) => r["entity_id"] == "octopus_energy_electricity_21e5388127_1630000294385_current_rate" and r["_field"] == "value")
    |> window(every: 30m)
    |> mean()
    |> map(fn: (r) => ({_value: r._value, _time: r._stop}))

join.time(method: "left",  left: usage, right: cost, as: (l, r) => ({l with cost: r._value}))
  |> map(fn: (r) => ({_value: r._value * r.cost}))
  |> sum()
  |> map(fn: (r) => ({_value: r._value * 0.001, _time: now()}))
2

I have added a PR for this feature here -