influxdb3 write and query support for string, file, or stdin input

[sanderson]

The influxdb3 write and influxdb3 query commands should both support input via string, file, or stdin.

Currently, influxdb3 write only supports writing line protocol from a file. I would propose supporting all of the following:

# string
$ influxdb3 write --database EXAMPLE_DB 'home,room=Living\ Room temp=21.1,hum=35.9,co=0i 1736841600'

# file
$ influxdb3 write --database EXAMPLE_DB --file /path/to/data.lp

# stdin
$ cat ./data.lp | influxdb3 write --database EXAMPLE_DB -

Current, the influxdb3 query command only lets you pass the query via a string argument. I would propose supporting all of the following:

# string
$ influxdb3 query --database EXAMPLE_DB 'SELECT * FROM home'

# file
$ influxdb3 query --database EXAMPLE_DB --file /path/to/query.sql

# stdin
$ cat ./query.sql | influxdb3 query --database EXAMPLE_DB -

Use case:
Adding this functionality would bring these commands closer to parity with influxctl write and influxctl query.

Proposal:
Add support for string-, file-, and stdin-based input for influxdb3 write and influxdb3 query commands.

Related issues:

• [Feature Request] support reading SQL/InfluxQL from a file and stdin #25772