Helge Heß on Nostr: Just use different connections for different threads, exactly the same way you do it ...

Just use different connections for different threads, exactly the same way you do it w/ MySQL. Then everything will be fine, the issue is exclusively if you use a single *connection* from multiple threads. Which unlike in regular DB's is actually possible in SQLite (if SQLite is compiled w/ the right flags). But still not advisable.
By "handle" you mean a prepared statement? Yeah, the last-id is bound to the connection, not to a statement.