Quick example on how some kind of repository pattern can be implemented for Drizzle

repository.ts

import { MySqlTable } from "drizzle-orm/mysql-core";
import { db as drizzleDb } from "./mysql/mysql2";
import { eq } from "drizzle-orm";
import { users } from "./mysql/schema";

interface Reader<T extends MySqlTable & { id: any }> {
  findAll(): Promise<T["$inferSelect"][]>;
  findOne(id: number): Promise<T["$inferSelect"] | undefined>;
}

export abstract class Repository<T extends MySqlTable & { id: any }>
  implements Reader<T>
{
  constructor(
    private db: typeof drizzleDb,
    private table: T,
  ) {}

  findAll() {
    return this.db.select().from(this.table).execute();
  }

  async findOne(id: number) {
    return (
      await this.db
        .select()
        .from(this.table)
        .where(eq(this.table.id, id))
        .execute()
    ).at(0);
  }
}

class UserRepository<
  T extends MySqlTable & { id: any },
> extends Repository<T> {} // You can extend with other methods if you want

const usersRepository = new UserRepository(drizzleDb, users);

const user = await usersRepository.findOne(1);

console.log(user);