PSA: WRITE TRANSACTIONS ARE A FOOTGUN WITH SQLX AND SQLITE

Summary from the TLDR Dev newsletter

Using async write transactions that yield with `await` in SQLx with SQLite is a footgun, as it holds the exclusive SQLite write lock across `await`s, leading to lock starvation and performance degradation.