I tried a quick search for “sqlite [dynamic] typ{e,ing} pitfalls”, but got mostly irrelevant results.

Can anyone please share common pitfalls of $subj issue? (Apart from obvious “you can insert a mess into a column and get hit by it later”)