Validator for custom query

[Sparticuz]

I'm wondering how to make a validator for a custom query. For example, I have a function that pulls from three tables using inner joins, but find myself needing to write a validator manually and making sure it matches close enough to my database. I believe the answer is making a function that will return a drizzle query, running a createInsertSchema on that object, then be able to execute that object elsewhere to get the results.

Maybe something like this

const getNoteQuery = () => database
    .select({
      addedDate: notesTable.addedDate,
      author: notesTable.caller,
      authorName: employees.fullName,
      id: notesTable.id,
  ...
      locationUpdated: prospectTable.location_updated,
      locationX: prospectTable.location_x,
      locationY: prospectTable.location_y,
    })
    .from(notesTable)
    .innerJoin(prospectTable, eq(prospectTable.id, notesTable.prospect))
    .innerJoin(employees, eq(employees.userName, notesTable.caller))
    .innerJoin(
      zipCodes,
      eq(zipCodes.zipCode, prospectTable.building_addressZipCode),
    )
    .$dynamic();

export const updateNoteSchema = createUpdateSchema(getNoteQuery);

export const getNote = async (id: number) => {
	return getNoteQuery().where(eq(notesTable.id, id));
}

Now I have both the updateNoteSchema, which gives me a zod/etc... schema, as well as, a getNote function that will return the note I request.