SQLite puts all of the responsibility on users to handle this

Thanks for the explanation.
I feel like the one who decided this behaviour, expected the users of the database, to make their own system of prioritising the transactions.