Best way to define a type for any table with a given column?

[nickhall]

I'm trying to define a dynamic query to provide some shared logic, but one caveat is that the table/column that needs to be referenced in this shared logic is dynamic, so I need to allow passing in both the original query builder as well as any table that has the given column.

const withSharedLogic = <T extends PgSelect>(
  builder: T,
  dynamicTable: AnyTableWithColumns<{ myValue: number; }>, // how to type this?
) {
  return builder.where(eq(dyamicTable.myValue, 123)); // dummy query
}

What's the best type to use here for AnyTableWithColumns? Is it even possible to achieve this with the desired API? I've seen old advice suggesting things like AnyTable & { myValue: number }, but that just throws type errors now. I found { myValue: SQLWrapper } works, but there's some loss of type information there. It's also possible to pass in a verbose definition for PgColumn, but that's cumbersome.

This discussion seems similar, but nothing there points me in the right direction: #442

Is there a way to achieve this with the current API?