Django Ticket 10070 reports an issue "Named parameters not working on raw sql queries with sqlite"

This is my attempt to try and figure out what is going on.

Side note: I initially marked this ticket as done at Django Con US 2022 as it seemed to no longer be a bug based on review of test methods, but about a week after it was closed, it was re-opened and shown to be reproducible.