Proper query results inference

[machour]

I currently need to use SelectResult to type a function argument, but this type is only available from the generated types file:

import { b as SelectResult } from "drizzle-orm/select.types.d-c3e86d45";

My use case is for a generic GridView component, for the server side part.
I give it a query, it add sorts, pagination, filtering, and return the result set in items.
I want items to be inferred correctly from my selection in query

export async function gridViewLoader<
  Y extends ColumnsSelection,
  F extends Record<string, "not-null">
>({  query }: { query: MySqlSelect<any, Y, any, any>}): Promise<{
  items: Array<SelectResult<Y, any, F>>;
  pagination: PaginationData;
}> {

Usage:

const { items, pagination } =  await gridViewLoader({
        query: db
          .select({
            id: invoice.id,
            customerName: invoice.customerName,
            totalTtc: invoice.totalTtc,
            status: invoice.status,
            legalDate: invoice.legalDate,
          })
          .from(invoice),

With SelectResult (found by following links in my IDE), items seems correctly typed (although it seems to duplicate the returned types and change keys orders)

Questions:

1. Is there something in "drizzle-orm" I should be using instead of a type from a generated file, or should I open a feature request to have it properly exported?

2. I just know I typed my helper like a 🙈 and would appreciate pointers to do it better, avoiding anys, ..

3. Should I be using MySqlXxx types, or is there a non-dbms-specific equivalent ?

Thanks 🙏🏼

[dankochetov]

If SelectResult is not available from drizzle-orm/mysql-core / drizzle-orm, then it's a bug. Please check and create an issue if that's the case.

[machour]

Opened issue #637