The main advantage is also its biggest disadvantage: you CAN control the clustering of the rows... and you MUST control the clustering of the rows. SQLite won't give you an auto-incremented ID on a WITHOUT ROWID table. You have to assign the IDs yourself and SQLite won't help you.
SQLite can give you an auto incremented ID on a without row id table. You just need to have a unique index on the id.
The disadvantage is that you’ll never look at Postgres the same way again.
Yeah, one of the things postgres is missing. Yugabyte seems to be addressing this thankfully
Yep looks like it. They don't seem to use Postgres storage layer at all.