but the other one has decades of engineering effort and is based on real world problems

But the other one is not available to most and SQLite itself is "open-source" not "open-contributions" so extending SQLite is pretty much impossible at scale:

- no way to merge upstream

- no way to run full test-suit to be sure everything is tiptop