apache / apache/datafusion-sqlparser-rs

Snowflake CREATE PROCEDURE support

Open
#1,512 0 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.