---
title: "SqlResult"
description: "The `SqlResult` entity."
section: "Reference"
group: "Types"
order: 213
---

## Definition

```ts
interface SqlResult {
  columns: Array<{ name: string; type: string | null }>;
  rows: Array<Record<string, unknown>>;
  durationMs: number;
  rowsRead?: number | undefined;
  rowsWritten?: number | undefined;
}
```

## Fields

| Field         | Type                                             | Notes                                                                          |
| ------------- | ------------------------------------------------ | ------------------------------------------------------------------------------ |
| `columns`     | `Array<{ name: string; type: string \| null; }>` | `required` — Column metadata for each field in the result rows.                |
| `rows`        | `Array<Record<string, unknown>>`                 | `required` — Result rows as objects keyed by column name.                      |
| `durationMs`  | `number`                                         | `required` — Query execution time in milliseconds.                             |
| `rowsRead`    | `number \| undefined`                            | `optional` — Number of rows read by the query, when reported by the engine.    |
| `rowsWritten` | `number \| undefined`                            | `optional` — Number of rows written by the query, when reported by the engine. |