> If distributed transactions are involved, you can lose or damage data without even knowing it

How do you think distributed databases support transactions?

The methods are described in Designing Data-Intensive Applications by Martin Kleppmann, though you will hardly accept it for a modern book, even less for an overview of modern databases.