I gave up on INSERT OR REPLACE INTO in this issue, after 50+ comments and over a year of attempts:

• added_ms and updated_ms columns are not reliable in face of operations like INSERT OR REPLACE INTO #7

As an experiment today I tried dropping the entire codebase from https://gitingest.com/simonw/sqlite-chronicle plus an export of that thread using https://tools.simonwillison.net/github-issue-to-markdown into Opus 4.6, Gemini 3 Deep Think and GPT-5.2 just to see what they could do with it.

Opus and Gemini Deep Think both found new solutions! GPT-5.2 ran out of context.

Links:

• The giant 130KB prompt I used
• Opus 4.6 transcript
  • Here's a gist with the Opus findings and proof.py script
• Gemini 3 Deep Think transcript