apache / apache/datafusion-sqlparser-rs
Snowflake CREATE PROCEDURE support
- Dominant language
- Rust
- Stars
- 3.5k
- Forks
- 772
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 17
Description
Support for https://docs.snowflake.com/en/sql-reference/sql/create-procedure, for example:
```sql
CREATE OR REPLACE PROCEDURE get_top_sales()
RETURNS TABLE ()
```
Currently parsing fails:
> Expected: [EXTERNAL] TABLE or [MATERIALIZED] VIEW or FUNCTION after CREATE OR REPLACE, found: PROCEDURE
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the parser path that handles CREATE OR REPLACE and compare its current accepted forms with the Snowflake CREATE PROCEDURE example in the issue. Add coverage for the shown statement and verify that parsing no longer reports PROCEDURE as unexpected.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- rust, sql
- Domain
- compilers, databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100