[Feature request] Add COUNT NODE query on grafana visualization

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/iotdb/issues) and found nothing similar.

### Motivation

On grafana variables you have the choice to write an entire query without limitations has shown below:

(i use this query to count the number of cores of a virtual machine, each of which i take data from)

i can't use this syntax on the grafana visualization because i'm forced to use a SELECT statement:


### Solution

Add another drop-down selection with a full-customized query editior that allows you to use all the language provided queries as in the grafana variables

### Alternatives

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Start by comparing the Grafana visualization query editor with the unrestricted Grafana variables query input described in the issue. Define the full-query flow, including COUNT NODE, and verify that visualization no longer forces a SELECT statement while retaining the existing query behavior.

Written by the indexing model from the issue text.