If I understand your use case and recent disappointment with it, the behavior you regret is now avoided by checkin https://sqlite.org/src/info/733b7d4f95a4e2f0 . Unless Richard dislikes it for some yet-to-be-fathomed reason, it should appear in the next release. I'm still interested in your argument for eliminating auto-headers if it survives this alternative remedy.