> That to me sounds like a good way to amplify a bug whereby a foreign key has not been defined¹ where it should be.
Good, as it should be.
> I hope there are copious warnings about it in the docs and when creating a table that way.
It is, SQLite’s docs are great and explain how it works in great detail.