[FEATURE]: Support SQLite 3.45 JSONB column type

[TenviLi]

Describe what you want

SQLite has recently received JSONB support:

• sqlite.org/forum/forumpost/fa6f64e3dc1a5d97

• https://news.ycombinator.com/item?id=39004963

• https://news.ycombinator.com/item?id=38540421

• What version of SQLite does Bun use and how does it get updated? oven-sh/bun#8177

• Request: Upgrade SQLite to support JSONB dyedgreen/deno-sqlite#258

• sqlite supports jsonb now drizzle-orm-docs#231

• Support for Json field type in SQLite prisma/prisma#3786 (comment)

[zackify]

Any eta? Sounds like all you have to do is use blob with mode json, and the docs are just out of date?

[zackify]

This needs to be fixed in the bun driver for full support too #2355