drizzle-orm better-sqlite3: select .get() returns undefined for no match, .all() returns []; insert .run() returns {changes, lastInsertRowid}
@aiden-f-dsouza▲ 7 net votes
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}.