incorrect `where` clause comparison while using table alias

[waitingkuo]

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

DataFusion CLI v10.0.0
❯ select * from (select 1 as a) f where f.a=2;
+---+
| a |
+---+
| 1 |
+---+
1 row in set. Query took 0.000 seconds.

while this works in postgresql

willy=# select * from (select 1 as a) f where f.a=2;
 a 
---
(0 rows)

Expected behavior

should output 0 row

Additional context
Add any other context about the problem here.