Json in sqlite

[fading wadi]

Why is json not supported in the sqlite data schema? I think this is a necessary function that can be implemented in automatic deserialization / serialization in string mode

I found this feature in drrizle orm, and I think it's convenient because it's troublesome to manually reverse / sequence in string every time

[hearty minnow]

You can use client extensions to do this

[grizzled cargo]

Hey there @fading wadi 👋 you've probably seen this already, but we have an open feature request for this: https://github.com/prisma/prisma/issues/3786 You can help us prioritize this by leaving a 👍 on the GitHub issue and a comment with your use case 🙏

Also, you could indeed implement the deserialization / serialization via a Prisma Client extension as David pointed out, more info here: https://www.prisma.io/docs/concepts/components/prisma-client/client-extensions 🤗

Hope that helps!