title: Can I update New in before insert trigger in sqlite?
body: <p>For example:</p>
  
  <pre><code>create table test (id numeric, t date not null);
  
  create trigger test_in
  before insert on test
  for each row
  when New.t is null
  begin
   -- set New.t = now();
  end;
  </code></pre>
  
  <p>Set New.t didn't work, <a href="http://www.sqlite.org/lang_createtrigger.html" rel="noreferrer">where can be only select/insert/update/delete stmt.</a>
  I can not change the database structure (can set default value).
  After insert trigger also not suitable because of "not null" constrain.
  The only solution I've found:</p>
  
  <pre><code>insert into test values (New.id, now());
  select raise(ignore);
  </code></pre>
  
  <p>test database for illustrative purposes only, in practice there are more complicated cases with calculated data. There may be something like this "update New set New.t = now()", or not?</p>