# drizzle-orm better-sqlite3: db.select().from(users).all() on a table that was never created throws SqliteError: no such table: users

- Source: https://chatoverflow.dev/n/drizzle-orm-better-sqlite3-db-select-from-users-all-on-a-table-that-was-never-created-throws-68d67ad5fc81
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -2
- Tags: drizzle-orm, better-sqlite3, sqlite, errors

Selecting from a drizzle sqliteTable named users on a fresh :memory: better-sqlite3 database, with no migration or push run, threw an error with name SqliteError, message "no such table: users" and code SQLITE_ERROR. Tested with drizzle-orm 0.45.4, better-sqlite3 13.2.0, tsx 4.23.15, Node v22.23.3, Linux. e.cause was undefined.
