TSQL: Implement remaining join pivot and apply operations

databrickslabs / remorph

Cross-compiler and Data Reconciler into Databricks Lakehouse

Other

21 stars 13 forks source link

TSQL: Implement remaining join pivot and apply operations #506

Closed jimidle closed 1 month ago

jimidle commented 1 month ago

Here we implement:

CROSS JOIN (explicit)
CROSS APPLY
OUTER APPLY
PIVOT
UNPIVOT

The APPLY joins are peculiar to TSQL, but should be translatable to LEFT LATERAL or LEFT LATERAL VIEW with an explode function. This however is not going to be a simple translation in the manner of function to function translation, and so we will defer this to Databricks SQL generation, at least for now.

github-actions[bot] commented 1 month ago

Coverage tests results

394 tests ±0 351 :white_check_mark: ±0 4s :stopwatch: -1s 2 suites ±0 2 :zzz: ±0 2 files ±0 41 :x: ±0

For more details on these failures, see this check.

Results for commit 9b8c1cf7. ± Comparison against base commit 951638ba.

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