📄 tanstack/db/latest/docs/reference/type-aliases/GetResult

File: GetResult.md | Updated: 11/15/2025

Source: https://tanstack.com/db/latest/docs/reference/type-aliases/GetResult



TanStack

DB v0v0

Search...

+ K

Auto

Log In

TanStack StartRC

Docs Examples GitHub Contributors

TanStack Router

Docs Examples GitHub Contributors

TanStack Query

Docs Examples GitHub Contributors

TanStack Table

Docs Examples Github Contributors

TanStack Formnew

Docs Examples Github Contributors

TanStack DBbeta

Docs Github Contributors

TanStack Virtual

Docs Examples Github Contributors

TanStack Paceralpha

Docs Examples Github Contributors

TanStack Storealpha

Docs Examples Github Contributors

TanStack Devtoolsalpha

Docs Github Contributors

More Libraries

Maintainers Partners Support Learn StatsBETA Discord Merch Blog GitHub Ethos Brand Guide

Documentation

Framework

React logo

React

Version

Latest

Search...

+ K

Menu

Getting Started

Guides

Collections

Frameworks

Community

API Reference

Framework

React logo

React

Version

Latest

Menu

Getting Started

Guides

Collections

Frameworks

Community

API Reference

On this page

GetResult

Copy Markdown

Type Alias: GetResult<TContext>
===============================

ts

type GetResult<TContext> = Prettify<TContext["result"] extends object ? TContext["result"] : TContext["hasJoins"] extends true ? TContext["schema"] : TContext["schema"][TContext["fromSourceName"]]>;


type GetResult<TContext> = Prettify<TContext["result"] extends object ? TContext["result"] : TContext["hasJoins"] extends true ? TContext["schema"] : TContext["schema"][TContext["fromSourceName"]]>;

Defined in: packages/db/src/query/builder/types.ts:653

GetResult - Determines the final result type of a query

This type implements the logic for what a query returns based on its current state:

Priority Order:

  1. Explicit Result: If select() was called, use the projected type
  2. Join Query: If joins exist, return all tables with proper optionality
  3. Single Table: Return just the main table from from()

Examples:

typescript

// Single table query:
from({ users }).where(...) // → User[]

// Join query without select:
from({ users }).leftJoin({ orders }, ...) // → { users: User, orders: Order | undefined }[]

// Query with select:
from({ users }).select({ id: users.id, name: users.name }) // → { id: number, name: string }[]


// Single table query:
from({ users }).where(...) // → User[]

// Join query without select:
from({ users }).leftJoin({ orders }, ...) // → { users: User, orders: Order | undefined }[]

// Query with select:
from({ users }).select({ id: users.id, name: users.name }) // → { id: number, name: string }[]

The Prettify wrapper ensures clean type display in IDEs by flattening complex intersection types into readable object types.

Type Parameters
---------------
### TContext

TContext extends Context

Edit on GitHub

Home

Partners Become a Partner

Code RabbitCode Rabbit CloudflareCloudflare AG GridAG Grid NetlifyNetlify NeonNeon WorkOSWorkOS ClerkClerk ConvexConvex ElectricElectric SentrySentry PrismaPrisma StrapiStrapi UnkeyUnkey

scarf analytics