Grafana Variables in Query not working

[fYGn]

Describe the bug
Variables in queries are not working, they return no data but do not error out.

To Reproduce
Steps to reproduce the behavior:
This returns data: SELECT yesMatch, noMatch, imageReject, error FROM Captures where flightNumber = "100"
This does not: SELECT yesMatch, noMatch, imageReject, error FROM Captures where flightNumber = $flightNumber //of course the variable is selected in grafana, and the variables are setup correctly. I have tried vars with and without quotes as the field is a string.

Expected behavior
Data should be returned when using variables

Using Grafana cloud to connect to firestore firebase using fireql