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 ?