qualify error

[s-oravec]

import sqlglot as sg
from sqlglot.optimizer.qualify import qualify as sg_qualify

x = sg.parse_one(
    'select a as b, b as a from c',
    dialect='oracle',
)
print(sg_qualify(x, quote_identifiers=False))

# Actual:   SELECT c.a AS b, c.a AS a FROM c AS c
# Expected: SELECT c.a AS b, c.b AS a FROM c AS c

[georgesittas]

@tobymao quick heads up that Oracle doesn't seem to support lateral alias expansion, e.g. both of these are invalid:

-- "B": invalid identifier
with c as (select 1 as a) select a as b from c where b >= 1;
with c as (select 1 as a) select a as b, b as foo from c;