This reference doc is generated based on this [example schema](https://firebase.google.com/docs/reference/sql-connect.md.txt#graphql_schema).

Mutations define the write operations for modifying data in a GraphQL schema.

All mutations are generated based on customer defined [`@table`](https://firebase.google.com/docs/reference/sql-connect/gql/directive.md.txt#table) types.
Customer defined mutations are not supported.

## SQL Connect Generated

### mainTable_delete: [`MainTable_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#MainTable_KeyOutput)

✨ Delete a single [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) based on `id`, `key` or `first` and return its key (or `null` if not found).

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | The unique ID of the object. |
| `key` | [`MainTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Key) | The key used to identify the object. |
| `first` | [`MainTable_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_FirstRow) | Fetch the first row based on the filters and ordering. |

### mainTable_deleteMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Delete [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) objects matching `where` conditions (or `all`, if true). Returns the number of rows deleted.

| Field | Type | Description |
|---|---|---|
| `where` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | Filter condition to specify which rows to delete. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to delete all rows. |

### mainTable_insert: [`MainTable_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#MainTable_KeyOutput)

✨ Insert a single [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) into the table and return its key. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`MainTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Data) | Data object to insert into the table. |

### mainTable_insertMany: [`[MainTable_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#MainTable_KeyOutput)

✨ Insert [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) objects into the table and return their keys. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`[MainTable_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Data) | List of data objects to insert into the table. |

### mainTable_update: [`MainTable_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#MainTable_KeyOutput)

✨ Update a single [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) based on `id`, `key` or `first`, setting columns specified in `data`. Returns the key of the updated [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) or `null` if not found.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | The unique ID of the object. |
| `key` | [`MainTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Key) | The key used to identify the object. |
| `first` | [`MainTable_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_FirstRow) | Fetch the first row based on the filters and ordering. |
| `data` | [`MainTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Data) | Data object containing fields to be updated. |

### mainTable_updateMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Update [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) objects matching `where` conditions (or `all`, if true) according to `data`. Returns the number of rows updated.

| Field | Type | Description |
|---|---|---|
| `where` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | Filter condition to specify which rows to update. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to update all rows. |
| `data` | [`MainTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Data) | Data object containing fields to update. |

### mainTable_upsert: [`MainTable_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#MainTable_KeyOutput)

✨ Insert or update a single [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).

| Field | Type | Description |
|---|---|---|
| `data` | [`MainTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Data) | Data object to insert or update if it already exists. |

### mainTable_upsertMany: [`[MainTable_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#MainTable_KeyOutput)

✨ Insert or update [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) objects into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).

| Field | Type | Description |
|---|---|---|
| `data` | [`[MainTable_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Data) | List of data objects to insert or update if it already exists. |

### manyToManyJoinTable_delete: [`ManyToManyJoinTable_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToManyJoinTable_KeyOutput)

✨ Delete a single [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) based on `id`, `key` or `first` and return its key (or `null` if not found).

| Field | Type | Description |
|---|---|---|
| `key` | [`ManyToManyJoinTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Key) | The key used to identify the object. |
| `first` | [`ManyToManyJoinTable_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_FirstRow) | Fetch the first row based on the filters and ordering. |

### manyToManyJoinTable_deleteMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Delete [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) objects matching `where` conditions (or `all`, if true). Returns the number of rows deleted.

| Field | Type | Description |
|---|---|---|
| `where` | [`ManyToManyJoinTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Filter) | Filter condition to specify which rows to delete. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to delete all rows. |

### manyToManyJoinTable_insert: [`ManyToManyJoinTable_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToManyJoinTable_KeyOutput)

✨ Insert a single [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) into the table and return its key. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`ManyToManyJoinTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Data) | Data object to insert into the table. |

### manyToManyJoinTable_insertMany: [`[ManyToManyJoinTable_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToManyJoinTable_KeyOutput)

✨ Insert [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) objects into the table and return their keys. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`[ManyToManyJoinTable_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Data) | List of data objects to insert into the table. |

### manyToManyJoinTable_update: [`ManyToManyJoinTable_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToManyJoinTable_KeyOutput)

✨ Update a single [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) based on `id`, `key` or `first`, setting columns specified in `data`. Returns the key of the updated [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) or `null` if not found.

| Field | Type | Description |
|---|---|---|
| `key` | [`ManyToManyJoinTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Key) | The key used to identify the object. |
| `first` | [`ManyToManyJoinTable_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_FirstRow) | Fetch the first row based on the filters and ordering. |
| `data` | [`ManyToManyJoinTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Data) | Data object containing fields to be updated. |

### manyToManyJoinTable_updateMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Update [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) objects matching `where` conditions (or `all`, if true) according to `data`. Returns the number of rows updated.

| Field | Type | Description |
|---|---|---|
| `where` | [`ManyToManyJoinTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Filter) | Filter condition to specify which rows to update. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to update all rows. |
| `data` | [`ManyToManyJoinTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Data) | Data object containing fields to update. |

### manyToManyJoinTable_upsert: [`ManyToManyJoinTable_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToManyJoinTable_KeyOutput)

✨ Insert or update a single [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).

| Field | Type | Description |
|---|---|---|
| `data` | [`ManyToManyJoinTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Data) | Data object to insert or update if it already exists. |

### manyToManyJoinTable_upsertMany: [`[ManyToManyJoinTable_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToManyJoinTable_KeyOutput)

✨ Insert or update [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) objects into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).

| Field | Type | Description |
|---|---|---|
| `data` | [`[ManyToManyJoinTable_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Data) | List of data objects to insert or update if it already exists. |

### manyToOneExample_delete: [`ManyToOneExample_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToOneExample_KeyOutput)

✨ Delete a single [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) based on `id`, `key` or `first` and return its key (or `null` if not found).

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | The unique ID of the object. |
| `key` | [`ManyToOneExample_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Key) | The key used to identify the object. |
| `first` | [`ManyToOneExample_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_FirstRow) | Fetch the first row based on the filters and ordering. |

### manyToOneExample_deleteMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Delete [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) objects matching `where` conditions (or `all`, if true). Returns the number of rows deleted.

| Field | Type | Description |
|---|---|---|
| `where` | [`ManyToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Filter) | Filter condition to specify which rows to delete. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to delete all rows. |

### manyToOneExample_insert: [`ManyToOneExample_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToOneExample_KeyOutput)

✨ Insert a single [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) into the table and return its key. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`ManyToOneExample_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Data) | Data object to insert into the table. |

### manyToOneExample_insertMany: [`[ManyToOneExample_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToOneExample_KeyOutput)

✨ Insert [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) objects into the table and return their keys. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`[ManyToOneExample_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Data) | List of data objects to insert into the table. |

### manyToOneExample_update: [`ManyToOneExample_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToOneExample_KeyOutput)

✨ Update a single [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) based on `id`, `key` or `first`, setting columns specified in `data`. Returns the key of the updated [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) or `null` if not found.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | The unique ID of the object. |
| `key` | [`ManyToOneExample_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Key) | The key used to identify the object. |
| `first` | [`ManyToOneExample_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_FirstRow) | Fetch the first row based on the filters and ordering. |
| `data` | [`ManyToOneExample_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Data) | Data object containing fields to be updated. |

### manyToOneExample_updateMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Update [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) objects matching `where` conditions (or `all`, if true) according to `data`. Returns the number of rows updated.

| Field | Type | Description |
|---|---|---|
| `where` | [`ManyToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Filter) | Filter condition to specify which rows to update. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to update all rows. |
| `data` | [`ManyToOneExample_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Data) | Data object containing fields to update. |

### manyToOneExample_upsert: [`ManyToOneExample_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToOneExample_KeyOutput)

✨ Insert or update a single [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).

| Field | Type | Description |
|---|---|---|
| `data` | [`ManyToOneExample_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Data) | Data object to insert or update if it already exists. |

### manyToOneExample_upsertMany: [`[ManyToOneExample_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ManyToOneExample_KeyOutput)

✨ Insert or update [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) objects into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).

| Field | Type | Description |
|---|---|---|
| `data` | [`[ManyToOneExample_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Data) | List of data objects to insert or update if it already exists. |

### oneToOneExample_delete: [`OneToOneExample_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#OneToOneExample_KeyOutput)

✨ Delete a single [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) based on `id`, `key` or `first` and return its key (or `null` if not found).

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | The unique ID of the object. |
| `key` | [`OneToOneExample_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Key) | The key used to identify the object. |
| `first` | [`OneToOneExample_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_FirstRow) | Fetch the first row based on the filters and ordering. |

### oneToOneExample_deleteMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Delete [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) objects matching `where` conditions (or `all`, if true). Returns the number of rows deleted.

| Field | Type | Description |
|---|---|---|
| `where` | [`OneToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Filter) | Filter condition to specify which rows to delete. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to delete all rows. |

### oneToOneExample_insert: [`OneToOneExample_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#OneToOneExample_KeyOutput)

✨ Insert a single [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) into the table and return its key. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`OneToOneExample_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Data) | Data object to insert into the table. |

### oneToOneExample_insertMany: [`[OneToOneExample_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#OneToOneExample_KeyOutput)

✨ Insert [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) objects into the table and return their keys. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`[OneToOneExample_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Data) | List of data objects to insert into the table. |

### oneToOneExample_update: [`OneToOneExample_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#OneToOneExample_KeyOutput)

✨ Update a single [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) based on `id`, `key` or `first`, setting columns specified in `data`. Returns the key of the updated [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) or `null` if not found.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | The unique ID of the object. |
| `key` | [`OneToOneExample_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Key) | The key used to identify the object. |
| `first` | [`OneToOneExample_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_FirstRow) | Fetch the first row based on the filters and ordering. |
| `data` | [`OneToOneExample_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Data) | Data object containing fields to be updated. |

### oneToOneExample_updateMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Update [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) objects matching `where` conditions (or `all`, if true) according to `data`. Returns the number of rows updated.

| Field | Type | Description |
|---|---|---|
| `where` | [`OneToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Filter) | Filter condition to specify which rows to update. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to update all rows. |
| `data` | [`OneToOneExample_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Data) | Data object containing fields to update. |

### oneToOneExample_upsert: [`OneToOneExample_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#OneToOneExample_KeyOutput)

✨ Insert or update a single [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).

| Field | Type | Description |
|---|---|---|
| `data` | [`OneToOneExample_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Data) | Data object to insert or update if it already exists. |

### oneToOneExample_upsertMany: [`[OneToOneExample_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#OneToOneExample_KeyOutput)

✨ Insert or update [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) objects into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).

| Field | Type | Description |
|---|---|---|
| `data` | [`[OneToOneExample_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Data) | List of data objects to insert or update if it already exists. |

### stringTable_delete: [`StringTable_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#StringTable_KeyOutput)

✨ Delete a single [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) based on `id`, `key` or `first` and return its key (or `null` if not found).

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | The unique ID of the object. |
| `key` | [`StringTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Key) | The key used to identify the object. |
| `first` | [`StringTable_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_FirstRow) | Fetch the first row based on the filters and ordering. |

### stringTable_deleteMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Delete [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) objects matching `where` conditions (or `all`, if true). Returns the number of rows deleted.

| Field | Type | Description |
|---|---|---|
| `where` | [`StringTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Filter) | Filter condition to specify which rows to delete. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to delete all rows. |

### stringTable_insert: [`StringTable_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#StringTable_KeyOutput)

✨ Insert a single [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) into the table and return its key. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`StringTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Data) | Data object to insert into the table. |

### stringTable_insertMany: [`[StringTable_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#StringTable_KeyOutput)

✨ Insert [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) objects into the table and return their keys. Columns not specified in `data` will receive defaults (e.g. `null`).

| Field | Type | Description |
|---|---|---|
| `data` | [`[StringTable_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Data) | List of data objects to insert into the table. |

### stringTable_update: [`StringTable_KeyOutput`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#StringTable_KeyOutput)

✨ Update a single [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) based on `id`, `key` or `first`, setting columns specified in `data`. Returns the key of the updated [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) or `null` if not found.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | The unique ID of the object. |
| `key` | [`StringTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Key) | The key used to identify the object. |
| `first` | [`StringTable_FirstRow`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_FirstRow) | Fetch the first row based on the filters and ordering. |
| `data` | [`StringTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Data) | Data object containing fields to be updated. |

### stringTable_updateMany: [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)

✨ Update [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) objects matching `where` conditions (or `all`, if true) according to `data`. Returns the number of rows updated.

| Field | Type | Description |
|---|---|---|
| `where` | [`StringTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Filter) | Filter condition to specify which rows to update. |
| `all` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Set to true to update all rows. |
| `data` | [`StringTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Data) | Data object containing fields to update. |

### stringTable_upsert: [`StringTable_KeyOutput!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#StringTable_KeyOutput)

✨ Insert or update a single [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).

| Field | Type | Description |
|---|---|---|
| `data` | [`StringTable_Data!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Data) | Data object to insert or update if it already exists. |

### stringTable_upsertMany: [`[StringTable_KeyOutput!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#StringTable_KeyOutput)

✨ Insert or update [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable) objects into the table, based on the primary key. Returns the key of the newly inserted or existing updated [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).

| Field | Type | Description |
|---|---|---|
| `data` | [`[StringTable_Data!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Data) | List of data objects to insert or update if it already exists. |