[hanche]

A small (?) part of the answer is likely to be found in the massive amount of testing: https://sqlite.org/testing.html