Comment
New Contributor II

Great feature!

 

SELECT * EXCEPT (b, d.y)
FROM VALUES(1, 2, 3, named_struct('x', 10, 'y', 20, 'z', 30)) AS t(a, b, c, d);
a c d
-- -- -------------
1 3 {x: 10 y: 30}

d in the output should be "{x: 10 z: 30}".