drizzle-orm: [BUG]: Many TypeScript Compile Errors (drizzle-orm/neon-http ; Postgres)

What version of drizzle-orm are you using?

^0.28.6

What version of drizzle-kit are you using?

^0.19.13

Describe the Bug

During the build step for Typescript, I run into the same “10 errors in 9 files” within the drizzle-orm Node modules package. Reproduced in 3 different projects, one of new was fresh, following the instructions step-by-step for Neon integration over http, as Firebase Cloud Functions do not support Web Sockets (to my knowledge; I could be wrong.)

Step 1:

yarn add drizzle-orm @neondatabase/serverless
yarn add -D drizzle-kit

Step 2: Ensure your env contains the string you need and is being read, then -

import { neon, neonConfig } from '@neondatabase/serverless';
import { drizzle } from 'drizzle-orm/neon-http';
 
neonConfig.fetchConnectionCache = true;
 
const sql = neon(process.env.DRIZZLE_DATABASE_URL!);
const db = drizzle(sql);

Step 3:

yarn tsc

Build Errors (Same In all Projects Tested):

$ yarn build
yarn run v1.22.19
$ tsc
node_modules/drizzle-orm/mysql-core/db.d.ts:1:38 - error TS2307: Cannot find module 'mysql2/promise' or its corresponding type declarations.

1 import type { ResultSetHeader } from 'mysql2/promise';
                                       ~~~~~~~~~~~~~~~~

node_modules/drizzle-orm/mysql-core/query-builders/delete.d.ts:15:22 - error TS2420: Class 'MySqlDelete<TTable, TQueryResult, TPreparedQueryHKT>' incorrectly implements interface 'SQLWrapper'.
  Property 'getSQL' is missing in type 'MySqlDelete<TTable, TQueryResult, TPreparedQueryHKT>' but required in type 'SQLWrapper'.

15 export declare class MySqlDelete<TTable extends MySqlTable, TQueryResult extends QueryResultHKT, TPreparedQueryHKT extends PreparedQueryHKTBase> extends QueryPromise<QueryResultKind<TQueryResult, never>> implements SQLWrapper {
                        ~~~~~~~~~~~

  node_modules/drizzle-orm/sql/index.d.ts:47:5
    47     getSQL(): SQL;
           ~~~~~~~~~~~~~~
    'getSQL' is declared here.

node_modules/drizzle-orm/mysql-core/query-builders/select.d.ts:74:22 - error TS2515: Non-abstract class 'MySqlSelect<TTableName, TSelection, TSelectMode, TPreparedQueryHKT, TNullabilityMap>' does not implement inherited abstract member 'getSQL' from class 'MySqlSelectQueryBuilder<MySqlSelectHKT, TTableName, TSelection, TSelectMode, TNullabilityMap>'.

74 export declare class MySqlSelect<TTableName extends string | undefined, TSelection, TSelectMode extends SelectMode, TPreparedQueryHKT extends PreparedQueryHKTBase, TNullabilityMap extends Record<string, JoinNullability> = TTableName extends string ? Record<TTableName, 'not-null'> : {}> extends MySqlSelectQueryBuilder<MySqlSelectHKT, TTableName, TSelection, TSelectMode, TNullabilityMap> {
                        ~~~~~~~~~~~

node_modules/drizzle-orm/pg-core/query-builders/delete.d.ts:17:22 - error TS2420: Class 'PgDelete<TTable, TQueryResult, TReturning>' incorrectly implements interface 'SQLWrapper'.
  Property 'getSQL' is missing in type 'PgDelete<TTable, TQueryResult, TReturning>' but required in type 'SQLWrapper'.

17 export declare class PgDelete<TTable extends PgTable, TQueryResult extends QueryResultHKT, TReturning extends Record<string, unknown> | undefined = undefined> extends QueryPromise<TReturning extends undefined ? QueryResultKind<TQueryResult, never> : TReturning[]> implements SQLWrapper {
                        ~~~~~~~~

  node_modules/drizzle-orm/sql/index.d.ts:47:5
    47     getSQL(): SQL;
           ~~~~~~~~~~~~~~
    'getSQL' is declared here.

node_modules/drizzle-orm/pg-core/query-builders/select.d.ts:193:22 - error TS2515: Non-abstract class 'PgSelect<TTableName, TSelection, TSelectMode, TNullabilityMap>' does not implement inherited abstract member 'getSQL' from class 'PgSelectQueryBuilder<PgSelectHKT, TTableName, TSelection, TSelectMode, TNullabilityMap>'.

193 export declare class PgSelect<TTableName extends string | undefined, TSelection, TSelectMode extends SelectMode, TNullabilityMap extends Record<string, JoinNullability> = TTableName extends string ? Record<TTableName, 'not-null'> : {}> extends PgSelectQueryBuilder<PgSelectHKT, TTableName, TSelection, TSelectMode, TNullabilityMap> {
                         ~~~~~~~~

node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:1:23 - error TS1452: 'resolution-mode' assertions are only supported when `moduleResolution` is `node16` or `nodenext`.

1 /// <reference types="node" resolution-mode="require"/>
                        ~~~~

node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:2:23 - error TS2688: Cannot find type definition file for 'bun-types'.

2 /// <reference types="bun-types" />
                        ~~~~~~~~~

node_modules/drizzle-orm/sqlite-core/query-builders/query.d.ts:24:22 - error TS2420: Class 'SQLiteRelationalQuery<TType, TResult>' incorrectly implements interface 'SQLWrapper'.
  Property 'getSQL' is missing in type 'SQLiteRelationalQuery<TType, TResult>' but required in type 'SQLWrapper'.

24 export declare class SQLiteRelationalQuery<TType extends 'sync' | 'async', TResult> extends QueryPromise<TResult> implements SQLWrapper {
                        ~~~~~~~~~~~~~~~~~~~~~

  node_modules/drizzle-orm/sql/index.d.ts:47:5
    47     getSQL(): SQL;
           ~~~~~~~~~~~~~~
    'getSQL' is declared here.

node_modules/drizzle-orm/sqlite-core/query-builders/raw.d.ts:8:22 - error TS2420: Class 'SQLiteRaw<TRunResult>' incorrectly implements interface 'SQLWrapper'.
  Property 'getSQL' is missing in type 'SQLiteRaw<TRunResult>' but required in type 'SQLWrapper'.

8 export declare class SQLiteRaw<TRunResult> extends QueryPromise<TRunResult> implements SQLWrapper {
                       ~~~~~~~~~

  node_modules/drizzle-orm/sql/index.d.ts:47:5
    47     getSQL(): SQL;
           ~~~~~~~~~~~~~~
    'getSQL' is declared here.

node_modules/drizzle-orm/sqlite-core/query-builders/select.d.ts:74:22 - error TS2515: Non-abstract class 'SQLiteSelect<TTableName, TResultType, TRunResult, TSelection, TSelectMode, TNullabilityMap>' does not implement inherited abstract member 'getSQL' from class 'SQLiteSelectQueryBuilder<SQLiteSelectHKT, TTableName, TResultType, TRunResult, TSelection, TSelectMode, TNullabilityMap>'.

74 export declare class SQLiteSelect<TTableName extends string | undefined, TResultType extends 'sync' | 'async', TRunResult, TSelection, TSelectMode extends SelectMode = 'single', TNullabilityMap extends Record<string, JoinNullability> = TTableName extends string ? Record<TTableName, 'not-null'> : {}> extends SQLiteSelectQueryBuilder<SQLiteSelectHKT, TTableName, TResultType, TRunResult, TSelection, TSelectMode, TNullabilityMap> {
                        ~~~~~~~~~~~~


Found 10 errors in 9 files.

Errors  Files
     1  node_modules/drizzle-orm/mysql-core/db.d.ts:1
     1  node_modules/drizzle-orm/mysql-core/query-builders/delete.d.ts:15
     1  node_modules/drizzle-orm/mysql-core/query-builders/select.d.ts:74
     1  node_modules/drizzle-orm/pg-core/query-builders/delete.d.ts:17
     1  node_modules/drizzle-orm/pg-core/query-builders/select.d.ts:193
     2  node_modules/drizzle-orm/sqlite-core/columns/blob.d.ts:1
     1  node_modules/drizzle-orm/sqlite-core/query-builders/query.d.ts:24
     1  node_modules/drizzle-orm/sqlite-core/query-builders/raw.d.ts:8
     1  node_modules/drizzle-orm/sqlite-core/query-builders/select.d.ts:74
error Command failed with exit code 2.

Expected behavior

Expect TypeScript to be able to build. Confirmed errors exist in individual node_module files noted in build process as well

Environment & setup

Server Platform: Firebase Cloud Functions Node Version: 18 Database Type: Neon.tech PostgreSQL Connection Type: http, ssl TypeScript Version: “^4.9.0” Editor: VSCode