nuxt-boilerplate/server/api/notes.get.ts

import { db } from "~~/server/db";
import { notes } from "~~/server/db/schema";

export default defineEventHandler(async () => {
  return db.select().from(notes);
});