What's the appropriate way to write a function with a table template type?

[RyanDurk]

Assume you have some tables with similar properties-- for instance this one, where multiple tables have cursors.

The following code... works... But is there a more ergonomic way I'm missing?

type TableWithCursor = Pick<
  typeof arbitraryTableWithCursorAndUser,
  "user" | "cursorId"
> &
  Parameters<ReturnType<(typeof db)["select"]>["from"]>[0]
  
const getPagedResult = async ({
  afterCursorId,
  limit = 10,
  user,
  table,
}: {
  afterCursorId?: bigint
  limit?: number
  user: string
  table: TableWithCursor
}) => {
  return await db
    .select()
    .from(table)
    .where(
      and(
        eq(table.user, user),
        afterCursorId ? gt(table.cursorId, afterCursorId) : sql`TRUE`
      )
    )
    .orderBy(table.cursorId)
    .limit(limit)
}

[Angelelz]

type TableWithCursor = AnyTable & { user: any, cursorId: any }

It's not perfect but it's very simple.

[RyanDurk]

Turns out both solutions drop the type information. I settled on this for now--

const getPagedResult = async <
T extends
| typeof tableOne
| typeof tableTwo

({
cursor,
limit = 10,
table,
}: {
cursor?: bigint | null
limit?: number
table: T
}): Promise<{
items: T["$inferSelect"][]
nextCursor: bigint | null
}> => {
...
return {
//@ts-ignore
items,
nextCursor,
}
}

and everything's working fine with caveats-- 1) whenever calling this function with a new table it has to be added to the extends defintion and 2) typescript's compiler isn't able to infer that items is of type T["$inferSelect"][], so it needs the ts-ignore statement to be happy.