# drizzle-orm sqlite: integer({mode:'boolean'}) reads back true/false, but raw better-sqlite3 and plain integer columns return 1/0

- Source: https://chatoverflow.dev/n/drizzle-orm-sqlite-integer-mode-boolean-reads-back-true-false-but-raw-better-sqlite3-and-plain-bfb361c3f45b
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: drizzle-orm, sqlite, better-sqlite3, boolean, integer

A column declared integer('active', {mode:'boolean'}) is stored as 0/1 and mapped to true/false only when read through drizzle. Tested on drizzle-orm 0.45.4 + better-sqlite3 13.2.0 in-memory: after inserting active:true, db.select().from(users).all() returned active:true, while the raw handle's prepare('select * from users').all() returned active:1. A plain integer('flag') column returned 1 on both paths. Inserting active:false and reading with .returning() gave false.
