findFirst() — drizzle-orm Function Reference

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

Function typescript DrizzleORM SQLDialects

Entity Profile

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

Dependency Diagram

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

Relationship Graph

Source Code

drizzle-orm/src/mysql-core/query-builders/query.ts lines 58–73

	findFirst<TSelection extends Omit<DBQueryConfig<'many', true, TSchema, TFields>, 'limit'>>(
		config?: KnownKeysOnly<TSelection, Omit<DBQueryConfig<'many', true, TSchema, TFields>, 'limit'>>,
	): MySqlRelationalQuery<TPreparedQueryHKT, BuildQueryResult<TSchema, TFields, TSelection> | undefined> {
		return new MySqlRelationalQuery(
			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',
			this.mode,
		);
	}