Unable to end queries with semicolon

[jayceslesar]

Hey all,

I am actively using this datasource in my teams Grafana instance and it works great so far in terms of what we do with it except for not allowing queries to end with a semicolon.

For example show schemas from glue is valid but show schemas from glue; throws

error querying the database: trino: query failed (200 OK): "USER_ERROR: line 1:23: mismatched input ';'. Expecting: 'LIKE', <EOF>"

This seems out of line with when I run the trino client locally from my cli, and queries are required to end with a semicolon within that interaction.

Why is that?

[nineinchnick]

In grafana, you can only execute a single statement at once. So you don't need a semicolon. In cli, you can continue writing a query after pressing enter, so you use the semicolon to signal the end of it.

[jayceslesar]

No other datasource I have ever used in Grafana errors out when ending a query with a semicolon

[nineinchnick]

It sounds reasonable to trim it before sending the query to the server.