Is there a way to get typed results from executing a function on Postgres?

  interface Widget {
    id: number
    name: string
  }

  const widgets = (
      await db.execute(
        sql`select * from get_widgets()`
      )
    ).rows // Record<string, unknown>[]

const widgets: Widget[] = (
      await db.execute(
        sql`select * from get_widgets()`
      )
    ).rows as unknown as Widget[]