# RelationshipSubqueryPilotModule (/docs/core/reference/api/interfaces/RelationshipSubqueryPilotModule)



[@kysoql/core](/docs/core/reference/api) / RelationshipSubqueryPilotModule

Pilot-only features available while building a relationship subquery.

## Type Parameters [#type-parameters]

| Type Parameter                                              | Default type          |
| ----------------------------------------------------------- | --------------------- |
| `DB`                                                        | -                     |
| `TB` *extends* keyof `DB`                                   | -                     |
| `O`                                                         | -                     |
| `Depth` *extends* `ParentToChildDepth`                      | readonly \[`unknown`] |
| `FunctionMode` *extends* `RelationshipSubqueryFunctionMode` | `"none"`              |
| `ApexMode` *extends* `boolean`                              | `false`               |

## Methods [#methods]

<a id="api-offset" />

### offset() [#offset]

```ts
offset(offset): RelationshipSubqueryBuilder<DB, TB, O, Depth, FunctionMode, ApexMode>;
```

Opts into Salesforce's relationship-subquery OFFSET pilot, which Salesforce
says is not intended for production. The compiler requires the immediate
parent query to use a literal LIMIT 1.

#### Parameters [#parameters]

| Parameter | Type     |
| --------- | -------- |
| `offset`  | `number` |

#### Returns [#returns]

[`RelationshipSubqueryBuilder`](/docs/core/reference/api/interfaces/RelationshipSubqueryBuilder)\<`DB`, `TB`, `O`, `Depth`, `FunctionMode`, `ApexMode`>

***

<a id="api-clearoffset" />

### clearOffset() [#clearoffset]

```ts
clearOffset(): RelationshipSubqueryBuilder<DB, TB, O, Depth, FunctionMode, ApexMode>;
```

Returns a builder with the `OFFSET` clause removed.

#### Returns [#returns-1]

[`RelationshipSubqueryBuilder`](/docs/core/reference/api/interfaces/RelationshipSubqueryBuilder)\<`DB`, `TB`, `O`, `Depth`, `FunctionMode`, `ApexMode`>