Testing the recently welcome added "returning" clause for inserts with this query that does work in PostgreSQL but doesn't in SQLite: ==== create table test(id integer primary key, data text); with insdata as (insert into test(data) values('one') returning id) select * from insdata; ==== Is this a limitation of the current implementation ?