SQLite is Transactional

A transactional database is one in which all changes and queries
appear to be
Atomic, Consistent, Isolated, and Durable
(ACID).
SQLite implements
serializable
transactions that are atomic, consistent, isolated, and durable,
even if the transaction is interrupted by a program crash, an
operating system crash, or a power failure to the computer.

We here restate and amplify the previous sentence for emphasis:
All changes within a single transaction in SQLite either occur
completely or not at all, even if the act of writing the change
out to the disk is interrupted by

a program crash,

an operating system crash, or

a power failure.

The claim of the previous paragraph is extensively checked in the
SQLite regression test suite using a special test harness that
simulates the effects on a database file of operating system crashes
and power failures.