It's " WITHOUT ROWID" problem.
replyWhy would you force database to order rows on the drive according to random id?
If you had read the article, you'd have seen that UUIDv4 with Rowid was slightly slower than UUIDv7
replyWhy would you force database to order rows on the drive according to random id?