Variable with two identical left join tables

I have a sql of the form:
table1 t1 left join table1 t2 on ...

and I am trying to use the {{date}} variable to be linked to table1 t1 table. It seems that Metabase does not allow to use this variable if there are two identical tables in the statement. I was hoping to write something like t1.{{date}} ....Any solution?

Hi @ivobrabec
Currently you cannot use Field Filters with table aliases - see comments for possible workarounds: - upvote by clicking :+1: on the first post