apache / apache/datafusion-sqlparser-rs

table alias without as fails to parse

Open
#719 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
3.5k
Forks
772
Avg merge
4d 9h
Merged PRs (30d)
17

Description

Hello !

The following valid SQL statement fails to parse:

```sql
select my_alias.value from json_each('{"hello": "world"}') my_alias
```

It should parse the same as the following

```sql
select my_alias.value from json_each('{"hello": "world"}') AS my_alias
```

Contributor guide

No contributing guide indexed for this repository

Research direction

No source file or test is named in the issue. Start by running the two SQL examples against the parser and trace the FROM-clause table-alias entry point; done means the alias without AS parses successfully and behaves the same as the explicitly introduced alias.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust, sql
Domain
compilers, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.