Function first

first<T = Record<string, unknown>>(
    key: string,
    sql: string,
    bindings?: any[],
    options?: ReadOptions,
): Promise<T | null>
Retrieves the first record matching the query for a given primary key.

This function is useful for fetching a single record based on a primary key. It automatically routes the query to the correct shard based on the provided primary key, ensuring consistent data access.
Type Parameters
- T = Record<string, unknown>
  Type of the result record
Parameters
- key: string
  Primary key to route the query
- sql: string
  SQL statement with parameter placeholders
- bindings: any[] = []
  Parameter values to bind to the SQL statement
- Optionaloptions: ReadOptions
  Read guarantee for this call. A bare row has no meta, so use all to get a bookmark back
Returns Promise<T | null>
Promise that resolves to the first matching record, or null if not found
Throws
If query fails or routing fails

Throws
MIGRATION_LOOKUP_UNAVAILABLE when a tombstone lookup fails or names an unknown shard; MIGRATION_CHAIN_EXCEEDED on a move cycle or a chain past four hops. Both return not found with bestEffort.
Example
```
type User = {
  id: string;
  name: string;
  email: string;
};
// Get a specific user
const userResult = await first<User>('user-123',
  'SELECT * FROM users WHERE id = ?',
  ['user-123']
);

if (userResult) {
  console.log(`Found user: ${userResult.name}`);
}
```
- Defined in src/router.ts:2901