What type should I use for select().from(T)?

[mhamid3d]

I tried AnyPgTable, which works fine with insert() but for db.select().from() I get an error on from()

async function getAll<T extends AnyPgTable>(
    table: T
) {
    const query = db.select().from(table);
    ...
}

Argument of type 'T' is not assignable to parameter of type 'TableLikeHasEmptySelection<T> extends true ? DrizzleTypeError<"Cannot reference a data-modifying statement subquery if it doesn't contain a `returning` clause"> : T'.

[andrecopi]

Same issue...

[ethanpo2]

Same issue

[waynesbrain]

I have been using PgTable & Record<"id" | "other_field" | "that_id_need", AnyPgColumn> in order to accept table schemas as arguments to my functions, however sometimes I have to cast .from(table as any) to the query builder and if I do that I also have to cast the return type as well.

I just dumped a thing I'm working on for my own project where I want to have reusable functions that I can just pass my table schemas into - it's completely untested at this time, but I did a lot of work this week to figure out the Drizzle types. Check this comment for the small gist of it - #1644 (comment) - and expand the EDIT section to see the solution.

And here's the dump including today's progress - https://gist.github.com/waynesbrain/707547d58fda5f33bc452a8fdf54516a

[rinshadkv]

I had this same isssue , so i created some thing like this maybe this will help

export async function getRecordById<T extends Table>(table: T, id: number) {
  try {
    const tableName = getTableName(table);
    const query = sql`select * from ${sql.raw(tableName)} where id = ${id} AND is_deleted = false  limit 1`;
    const result = await db.execute(query);
    return result.rows;
  } catch (error) {
    console.error("Error fetching  record  ", error);
    throw error;
  }
}