[Tech Request]: support reference aliases in where clause

### Is there an existing issue for the same tech request?

- [X] I have checked the existing issues.

### Does this tech request not affect user experience?

- [X] This tech request doesn't affect user experience.

### What would you like to be added ?

```Markdown
support reference aliases in where clause, e.g.

select a as alias_a, b from t where alias_a > 1;
```

### Why is this needed ?

_No response_

### Additional information

_No response_