search

apache / datafusion-sqlparser-rs

Extensible SQL Lexer and Parser for Rust
Apache License 2.0
2.8k stars 543 forks source link

Snowflake CREATE PROCEDURE support #1512

Open psukys opened 1 week ago

psukys commented 1 week ago

Support for https://docs.snowflake.com/en/sql-reference/sql/create-procedure, for example:

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