databrickslabs / remorph

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

[FEATURE]: ADD Support for Non-ANSI Joins #552

Open sundarshankar89 opened 1 month ago

sundarshankar89 commented 1 month ago

Is there an existing issue for this?

Category of feature request

Transpile

Problem statement

NON ANSI Join select a.name,a.empno,b.loc from tab a, tab b where a.deptno=b.deptno(+);

ANSI Join select a.name,a.empno,b.loc from tab a left outer join tab b on a.deptno=b.deptno;