Executing raw Sql query

import {sql} from 'drizzle-orm'

// One way
const query = sql.raw('SELECT * from users')

// You can also use string interpolation
const table = "users"
const query = sql.raw(`SELECT * from ${table}`)

// Execute the query
await db.execute(query)

import "server-only";

import { db } from "@/db";
import { sql } from "drizzle-orm";

export async function runQuery(query: string) {
  const res = await db.execute(sql.raw(query));
  return res;
}

  const res = await runQuery(
    "select * from user"
  );

export const users = pgTable("user", {
  id: text("id")
    .primaryKey()
    .$defaultFn(() => uuidv4()),
  name: text("name").notNull(),
  password: text("password"),
  email: text("email").unique().notNull(),
  emailVerified: timestamp("emailVerified", { mode: "date" }),
  image: text("image")
    .default("https://cdn-icons-png.flaticon.com/512/1531/1531344.png")
    .notNull(),
  role: userRole("role").default("USER").notNull(),
  isTwoFactorEnabled: boolean("isTwoFactorEnabled").default(false).notNull(),
});