SQLite allows foreign keys on non-existing columns?

[penberg]

There's a report of SQLite allowing the creation of a foreign key on a non-existing column. Let's look into this to understand if that's really something SQLite is supposed to allow and then think about potential ways to prevent that in libSQL.