SQLite Forum

SQLite with insert returning not working as in PostgreSQL
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 ?