SQLite has a returing clause for INSERT;

see https://www.sqlite.org/lang_insert.html

demo:

sqlite> .schema test
CREATE TABLE temp.test(
id integer primary key autoincrement, value integer);

sqlite> insert into test (value) values (44) RETURNING id;
10