findFirst() — drizzle-orm Function Reference

Architecture documentation for the findFirst() function in query.ts from the drizzle-orm codebase.

Function typescript DrizzleORM QueryBuilders

Entity Profile

DrizzleORM→ QueryBuilders→ findFirst() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  0fd10905_cb33_1d41_3d74_d005c0963718["findFirst()"]
  00b41c4f_4e02_f219_eb9d_a3e981ad9878["RelationalQueryBuilder"]
  0fd10905_cb33_1d41_3d74_d005c0963718 -->|defined in| 00b41c4f_4e02_f219_eb9d_a3e981ad9878
  style 0fd10905_cb33_1d41_3d74_d005c0963718 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/src/pg-core/query-builders/query.ts lines 48–62

	findFirst<TSelection extends Omit<DBQueryConfig<'many', true, TSchema, TFields>, 'limit'>>(
		config?: KnownKeysOnly<TSelection, Omit<DBQueryConfig<'many', true, TSchema, TFields>, 'limit'>>,
	): PgRelationalQuery<BuildQueryResult<TSchema, TFields, TSelection> | undefined> {
		return new PgRelationalQuery(
			this.fullSchema,
			this.schema,
			this.tableNamesMap,
			this.table,
			this.tableConfig,
			this.dialect,
			this.session,
			config ? { ...(config as DBQueryConfig<'many', true> | undefined), limit: 1 } : { limit: 1 },
			'first',
		);
	}