[BUG]: Dealiasing for SnowFlake may introduce precedence issues

[ericvergnaud]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

TranspileLateralColumnAliasError

Current Behavior

Consider the following:

SELECT 
   a - b as c1,
   c * c1 as c2
FROM t
WHERE c2 > 0

This currently transpiles to:

SELECT 
   a - b as c1,
   c * c1 as c2
FROM t
WHERE c * a - b > 0

which probably behaves differently from expected

See #1242

Expected Behavior

A possible solution could be to transpile to:

SELECT 
   a - b as c1,
   c * c1 as c2
FROM t
WHERE c * (a - b) > 0

Steps To Reproduce

No response

Relevant log output or Exception details

No response

Sample Query

No response

Operating System

macOS

Version

latest via Databricks CLI