Unable to pass Grafana Variables as SQL Predicates

[tgtwm1github]

Bug Report

In other Data Sources (Postgresql for instance). If I create a variable in Grafana Dashboard. I can pass it as a predicate value.

For example" A variable call "variable1" can be passed in a SQL

select col1,col2 from table1 where col1='$variable1';

I am unable to do that in Bigquery.

However explicit values work.

For instance:

select col1,col2 from table1 where col1='EXPLICIT_VALUE'. <-------This works.

But not having the ability to pass variables is a serious limitation.

Expected Behavior

variables should be able to be passed along as predicates.

Actual Behavior

Steps to Reproduce the Problem

For example" A variable call "variable1" can be passed in a SQL

select col1,col2 from table1 where col1='$variable1';

I am unable to do that in Bigquery.

Specifications

• Version:2.0.1
• Platform: Linux
• Grafana Version: 7.3.5

[tgtwm1github]

Update:

This is an issue with Date Datatype.
Apologize for not documenting the exact error scenario I faced but trying to provide a similar scenario.
The variable passing works for STRING datatype but does not work for DATE.