databrickslabs / remorph

Cross-compiler and Data Reconciler into Databricks Lakehouse
Other
21 stars 13 forks source link

Add `LET` and `DECLARE` statements parsing in Snowflake PL/SQL procedures #548

Closed sundarshankar89 closed 2 weeks ago

sundarshankar89 commented 1 month ago

Added Grammar for DECLARE and LET statements RETURN Statement Parameterized Expression Refactor using ScalaSubquery

Added IR visitor for DECLARE and LET with Variable Assignment and ResultSet Assignment Not covered CURSOR

github-actions[bot] commented 1 month ago

Coverage tests results

401 tests  ±0   109 :white_check_mark: ±0   4s :stopwatch: ±0s   2 suites ±0     0 :zzz: ±0    2 files   ±0   292 :x: ±0 

For more details on these failures, see this check.

Results for commit 37d87c99. ± Comparison against base commit 1663d473.

:recycle: This comment has been updated with latest results.

nfx commented 4 weeks ago

@sundarshankar89 please add some functional examples of PL/SQL procedures with LET/DECLARE

sundarshankar89 commented 3 weeks ago

@vil1 and @nfx Ready for Review.