>"The only thing is that rqlite doesn't support distributed transactions in the usual sense, so there might be some difficulty mapping Postgres transaction control to rqlite."
Can you elaborate on this, in what sense does rqlite support distributed transactions?