title: INSERT, and get the auto-incremented value
body: <p>Consider the following table:</p>
  
  <pre><code>create table language (
      id integer generated always as identity (START WITH 1, INCREMENT BY 1),
      name long varchar,
      constraint language_pk primary key (id)
  );
  </code></pre>
  
  <p>To which I'd insert an entry this way.</p>
  
  <pre><code>insert into language(name) values ('value');
  </code></pre>
  
  <p>How does one know what value for <code>id</code> was created? Just doing a SELECT using the <code>name</code> field is not valid, because there can be duplicate entries.</p>