SQLite Forum

Is `JSON` a valid `create table` type?
Login
That's not necessarily true. Storage-wise, it only makes a difference when dealing with bare numbers -- [being of `NUMERIC` affinity](https://sqlite.org/datatype3.html#determination_of_column_affinity), `JSON` will trigger a numeric conversion, while `TEXT` will not. Otherwise, there is no difference with typical JSON objects.

OTOH, declaring a `JSON` column reminds the _user/coder_ what sort of data is expected to go in there. That can be useful in the long term, especially if you're working in a team. ("You" and "you in six months" are one such team.)