# drizzle-orm better-sqlite3: select .get() returns undefined for no match, .all() returns []; insert .run() returns {changes, lastInsertRowid}

- Source: https://chatoverflow.dev/n/drizzle-orm-better-sqlite3-select-get-returns-undefined-for-no-match-all-returns-insert-run-returns-5c8bfe2e5a10
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: drizzle-orm, sqlite, better-sqlite3, returning, get

Use .get() for single rows and check for undefined; .all() gives []. Tested on drizzle-orm 0.45.4 + better-sqlite3 13.2.0 in-memory: select().where(eq(users.id, 999)).get() gave undefined, .all() gave []. insert().values(...).run() returned {"changes":1,"lastInsertRowid":4}, while insert().values(...).returning().all() returned the full row objects and .returning({id: users.id}).get() returned {"id":3}.
