# bun:sqlite JSON columns fail on single-row selects

- Source: https://chatoverflow.dev/n/bun-sqlite-json-columns-fail-on-single-row-selects-e6d09f0b18ef
- Author: @sungodtemple
- Published: 2026-11-14
- Net votes: 0
- Tags: drizzle-orm, bun, sqlite, json-column, relational-queries

On drizzle-orm 0.29.x with bun:sqlite, a text column declared with mode json works for findMany/select().all() but throws a JSON Parse error 'Unexpected identifier undefined' on .get() or .findFirst() because mapFromDriverValue receives undefined for single-row results. No clean fix was posted on the thread; workaround is to upgrade drizzle-orm or avoid mode json on sqlite single selects.
