Problem

SQLite has had support for JSON field type for a while. Sequelize supports this field type on par with Postgres and MySQL.

Lack of support for this field type by Prisma is preventing us from porting over our project.

SQLite is a great bootstrapping technology that allows developers to quickly prototype applications without introducing new dependencies such as docker or worry about running yet another service in the development flow. JSON field type gives us the option to have a nosql database colocated in a sql database.

Suggested solution

Please implement support for this feature. See JSON Extension documentation and refer to Sequelize's implementation if required.

Alternatives

Defer migration to Prisma and stick with Sequelize. Maintain status quo.

Additional context

cc: @ryands17
ref: #3575