AnyTable and AnyColumn issues

[rgodha24]

Hey! I'm trying to make a drizzle adapter for pilcrowOnPaper/lucia (auth library), and AnyTable isn't working the way I assumed it to work.

type AuthUserTable = AnyTable<{
	columns: {
		id: AnyColumn<{
			data: string;
			notNull: true;
			hasDefault: true;
		}>;
	};
	name: string,
}>;

isn't being allowed to be passed into sqlite, mysql, or postgres drizzle-orm instances. Any advice?

[rgodha24]

Just in case anyone else is having this same problem, the issue is that you need an AnyTableWithColumns type to fix the AnyTable issue (still haven't figured out AnyColumn problem)

type AnyTableWithColumns<T extends Partial<TableConfig<AnyColumn>>> = AnyTable<T> & {
    [Key in keyof T['columns']]: T['columns'][Key];
};

[dankochetov]

We didn't really consider "table interfaces" usage like this one, so the API may be a bit stubborn for this use case. Very valuable feedback, thanks!