Fix Precommit Install & IDE Improvements

Fixed

• ci: fix precommit install by declaring optional dependencies (#1180)

• ide: fix select * w/ create view & more (#1184)

  The following now works correctly:

  create table t(a int);
  --             ^ dest
  create view v as table t;
  select a$0 from v;
  --     ^ src

• ide: treat select into like create table as (#1183)

  create table t(a bigint);
  --             ^ dest
  select * into u from t;
  select a from u;
  --     ^ src

• ide: fix column resolution with cte & shadowing (#1182)

  with outer_cte as (select 1 c)
  --                          ^ dest
  select * from (
    with inner_cte as (select 2 d)
    select c from outer_cte
  --       ^ src
  ) s;

• ide: fix aliases not hiding original name (#1181)

  create table t(a int);
  update t as u set a = t.a;
  --                    ^ error

• ide: fix cte & alias resolution (#1179)

    with
      a as (select * from b),
  --                      ^ src doesn't resolve
      b as (select 1 x)
    select * from a;

• ide: don't resolve trailing FromItems in a lateral subquery (#1177)

  with
    d as (select 1 id, 2 amount),
    c as (select 2 id)
  select r.amount
  from
    d,
    lateral (
      select d.amount
      from d
      where d.id = c.id
      --           ^ src doesn't resolve
      limit 1
    ) r,
    c;