JOIN without Alias does not work

## Issue
```sql
SELECT * FROM User JOIN Dept ON User.deptId = Dept.id;
```
Above Query does not work and gets `ParserError("Expected end of statement, found: .")`
It works fine in legacy Database like MySQL.

If it is bug, let me try to fix it.

Reproduce the SQL example and trace the parser error reported after the JOIN, focusing on JOIN handling and qualified column names. No files or tests are named in the issue, so first locate the relevant parser entry point and existing JOIN tests. Done means the query parses successfully without aliases and regression coverage demonstrates that behavior.

Written by the indexing model from the issue text.