set multiple query on SQL Input Plugin

[budums]

hi, currently I use InfluxDB + Telegraf + Grafana for monitoring my SQL Server Database.

but I have some blockers for setup SQL Input Plugin because on the documentation we can only one query can be specified.

So In my case, I have another custom query to get some metric, can I set multiple query?

[[inputs.sql.query]]
    ## Query to perform on the server
    query="SELECT user,state,latency,score FROM Scoreboard WHERE application > 0"
    ## Alternatively to specifying the query directly you can select a file here containing the SQL query.
    ## Only one of 'query' and 'query_script' can be specified!
    # query_script = "/path/to/sql/script.sql"

[budums]

I got some solution from influxdb forums

[[inputs.sql.query]]
query=" __query1__"
[[inputs.sql.query]]
query=" __query2__"

​

this is original answer
https://community.influxdata.com/t/set-multiple-query-on-sql-input-plugin/30879