Item names including a Dollar-sign are modified by datasource plugin

[jbsgh]

To reproduce

Using item names including a Dollar sign (e. g. "my$item") are modified by the datasource plugin

Steps to reproduce:

1. Switch to SQL Editor
2. Enter simple SQL statement: SELECT time,my$item FROM "my_table"; (this query shouldn't be too complex to convert)
3. Switch to Query Builder; Confirm warning

Observations:

1. The query is of type "Time series"
2. The SQL preview contains SELECT time as time FROM "my_table" WHERE $__timeFilter(time) SAMPLE BY $__sampleByInterval LIMIT 100. my$item is missing

Steps to reproduce:
4. Switch to Query Type "Table"

Observations:
3. The field "time" is missing now
4. The listbox "Fields" contains myf9qx7sitem instead of my$item
5. The SQL Preview contains SELECT myf9qx7sitem FROM "my_table" LIMIT 100
6. The Dollar sign of field "my$item" has been replaced with a random string like "f9qx7s"

QuestDB version:

8.0.1

Grafana version:

11.1.0

Plugin version:

0.13.0

OS, in case of Docker specify Docker and the Host OS:

Debian 12

Full Name:

Jan Bartels

Affiliation:

Siempelkamp

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response