Is it possible to dynamically reference a table and column ?

[choff5507]

I am trying to do something like:
like(table.column, 'somestring')

Basically I am trying to dynamically build queries. But I want to be able to feed the table and column dynamically into the method I have.

But I cannot seem to find a way to properly reference a table and column dynamically. Trying to do something like a string literal obviously doesn't work. Is this possible? Would appreciate any help. Thanks!

[j-fdion]

I did something like that:

      type fields = keyof (typeof Instructor)["_"]["columns"];

      const filters = input.columnFilters.map(
        (f) => sql`${Instructor[f.id as fields]} ILIKE ${f.value + "%"}::text`,
      );
      const filterBy = sql.join(filters, "and");

      const countQuery = await ctx.db
        .select({ value: count() })
        .from(Instructor)
        .where(filterBy.if(filters.length > 0));

columnFilters is a tuple composed like this: {id: 'NameOfMyField', value: 'filter value'}

[hunterwilhelm]

Here's another way by using sql.identifier

sql`
DELETE FROM ${sql.identifier(getTableName(yourTableName))}
...
`