SQLite Forum

Proposed JSON enhancements.
Login
Thanks for your great work.
How about add a new "json" type in the new strict table mode, the parser translate  column definition into json check(json_valid(x)=1)
ex:
   create table t(data json) strict;
transform to 
   create table t(data json check(json_valid(data)=1)) strict;