[FEATURE REQUEST] Escaping Characters in UQL queries

[Morriden]

support for 'escaping characters' in UQL queries? Additionally, it would be helpful to handle the bug of ignoring the '(' and ')' characters in queries.

How do we reproduce it?:

• 1- Select an Infinity plugin datasource in your panel.

• 2- Sample JSON api response:

{
"total": 2,
"source": [
{
"country": "Canada",
"adSAMId": "xxxxxxxx",
"dataType": "employeeData",
"index": "desgdsdata",
"type": "employeeData",
"id": "xxxxxxxx"
},
{
"country": "United Kingdom (GB)",
"adSAMId": "yyyyyyyy",
"dataType": "employeeData",
"index": "desgdsdata",
"type": "employeeData",
"id": "yyyyyyyy"
}
]
}

• 3-select UQL query:

parse-json
| scope "source"
| project "country", "adSAMId"
| extend "country"=replace_string("country",'(GB)','test')

The result of country is like "United Kingdom (test)" instead of "United Kingdom test". It seems the special chars like parenthesis are ignored and not possible to replace them.

*All below alternatives tried and not possible to escape paranthesis.

replace_string("country",'(GB)','test')
replace_string("country",'`$(GB`$)','test')
replace_string("country",'$(GB$)','test')
replace_string("country",'\(GB\)','test')
replace_string("country",'\(','')*