member_over_if_struct.sql 202 B

1234
  1. insert into plato.Output
  2. select * from (select IF(key == "foo", LAG(data) over w, data) from
  3. (select TableRow() as data, key, value from plato.Input)
  4. window w as (partition by key)) flatten columns;