SQLite Forum

insert into view returning id returns null
expected behaviour? take all inserted rows, apply view in read mode on them, and return expression referring result of this read.

Multiple inserts in fact were primary reason why I tried this. Than magic with last_insert_rowid will be not sufficient enough.