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

Input Object types define structured inputs that can be used as arguments in a GraphQL schema.

SQL Connect generates input types to work with built in scalars and developer defined [`@table`](https://firebase.google.com/docs/reference/sql-connect/gql/directive.md.txt#table) types.

## SQL Connect Defined

### input Any_Filter

Query filter criteria for [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) scalar fields.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | When true, match if field `IS NULL`. When false, match if field is `NOT NULL`. |
| `eq` | [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Match if field is exactly equal to provided value. |
| `eq_expr` | [`Any_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any_Expr) | Match if field is exactly equal to the result of the provided server value expression. |
| `ne` | [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Match if field is not equal to provided value. |
| `ne_expr` | [`Any_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any_Expr) | Match if field is not equal to the result of the provided server value expression. |
| `in` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Match if field value is among the provided list of values. |
| `nin` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Match if field value is not among the provided list of values. |

### input Any_ListFilter

Query filter criteria for [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) scalar fields.

| Field | Type | Description |
|---|---|---|
| `includes` | [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Match if list field contains the provided value as a member. |
| `excludes` | [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Match if list field does not contain the provided value as a member. |
| `includesAll` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Match if list field contains all of the provided values as members. |
| `excludesAll` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Match if list field does not contain any of the provided values as members. |

### input Any_ListUpdate

Update input of an [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Append the provided list of values to the existing list. |
| `prepend` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Prepend the provided list of values to the existing list. |
| `add` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Append values that do not already exist to the list. |
| `remove` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | Remove all occurrences of each value from the list. |

### input Boolean_Filter

Query filter criteria for [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) scalar fields.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | When true, match if field `IS NULL`. When false, match if field is `NOT NULL`. |
| `eq` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if field is exactly equal to provided value. |
| `eq_expr` | [`Boolean_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean_Expr) | Match if field is equal to the result of the provided expression. |
| `ne` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if field is not equal to provided value. |
| `ne_expr` | [`Boolean_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean_Expr) | Match if field does not match the result of the provided expression. |
| `in` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if field value is among the provided list of values. |
| `nin` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if field value is not among the provided list of values. |

### input Boolean_ListFilter

Query filter criteria for [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) scalar fields.

| Field | Type | Description |
|---|---|---|
| `includes` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if list field contains the provided value as a member. |
| `excludes` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if list field does not contain the provided value as a member. |
| `includesAll` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if list field contains all of the provided values as members. |
| `excludesAll` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if list field does not contain any of the provided values as members. |

### input Boolean_ListUpdate

Update input of a [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Append the provided list of values to the existing list. |
| `prepend` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Prepend the provided list of values to the existing list. |
| `add` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Append values that do not already exist to the list. |
| `remove` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Remove all occurrences of each value from the list. |

### input Date_Duration

| Field | Type | Description |
|---|---|---|
| `days` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of days for the duration. |
| `weeks` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of weeks for the duration. |
| `months` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of months for the duration. |
| `years` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of years for the duration. |

### input Date_Filter

Conditions on a [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) value.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if the field `IS NULL`. |
| `eq` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the field is exactly equal to the provided value. |
| `eq_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | Match if the field equals the provided CEL expression. |
| `eq_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | Match if the field equals the provided relative date. |
| `ne` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the field is not equal to the provided value. |
| `ne_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | Match if the field is not equal to the provided CEL expression. |
| `ne_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | Match if the field is not equal to the provided relative date. |
| `in` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the field value is among the provided list of values. |
| `nin` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the field value is not among the provided list of values. |
| `gt` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the field value is greater than the provided value. |
| `gt_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | Match if the field value is greater than the provided CEL expression. |
| `gt_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | Match if the field value is greater than the provided relative date. |
| `ge` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the field value is greater than or equal to the provided value. |
| `ge_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | Match if the field value is greater than or equal to the provided CEL expression. |
| `ge_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | Match if the field value is greater than or equal to the provided relative date. |
| `lt` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the field value is less than the provided value. |
| `lt_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | Match if the field value is less than the provided CEL expression. |
| `lt_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | Match if the field value is less than the provided relative date. |
| `le` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the field value is less than or equal to the provided value. |
| `le_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | Match if the field value is less than or equal to the provided CEL expression. |
| `le_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | Match if the field value is less than or equal to the provided relative date. |

### input Date_ListFilter

Conditions on a[`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) list.

| Field | Type | Description |
|---|---|---|
| `includes` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the list contains the provided date. |
| `includes_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | Match if the list contains the provided date CEL expression. |
| `includes_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | Match if the list contains the provided relative date. |
| `excludes` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the list does not contain the provided date. |
| `excludes_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | Match if the list does not contain the provided date CEL expression. |
| `excludes_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | Match if the list does not contain the provided relative date. |
| `includesAll` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the list contains all the provided dates. |
| `excludesAll` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Match if the list contains none of the provided dates. |

### input Date_ListUpdate

Update input of a [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Append the provided [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) values to the existing list. |
| `prepend` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Prepend the provided [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) values to the existing list. |
| `add` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Append any [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) values that do not already exist to the list. |
| `remove` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | Remove all occurrences of each [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) from the list. |

### input Date_Relative

A runtime-calculated Date value relative to `today` or `on`.

| Field | Type | Description |
|---|---|---|
| `today` | [`True`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#True) | Match for today's date. |
| `on` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | A specific date for matching. |
| `add` | [`Date_Duration`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Duration) | Add the provided duration to the base date. |
| `sub` | [`Date_Duration`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Duration) | Subtract the provided duration from the base date. |
| `truncateTo` | [`Date_Interval`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#Date_Interval) | Truncate the date to the provided interval. |

### input Date_Update

Update input of a [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) value. Only one of `inc` or `dec` may be specified.

| Field | Type | Description |
|---|---|---|
| `inc` | [`Date_Duration`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Duration) | Increment the field by a provided duration. |
| `dec` | [`Date_Duration`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Duration) | Decrement the field by a provided duration. |

### input Float_Filter

Query filter criteria for [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) scalar fields.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | When true, match if field `IS NULL`. When false, match if field is `NOT NULL`. |
| `eq` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if field is exactly equal to provided value. |
| `eq_expr` | [`Float_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float_Expr) | Match if field is exactly equal to the result of the provided server value expression. |
| `ne` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if field is not equal to provided value. |
| `ne_expr` | [`Float_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float_Expr) | Match if field is not equal to the result of the provided server value expression. |
| `in` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if field value is among the provided list of values. |
| `nin` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if field value is not among the provided list of values. |
| `gt` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if field value is greater than the provided value. |
| `gt_expr` | [`Float_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float_Expr) | Match if field value is greater than the result of the provided server value expression. |
| `ge` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if field value is greater than or equal to the provided value. |
| `ge_expr` | [`Float_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float_Expr) | Match if field value is greater than or equal to the result of the provided server value expression. |
| `lt` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if field value is less than the provided value. |
| `lt_expr` | [`Float_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float_Expr) | Match if field value is less than the result of the provided server value expression. |
| `le` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if field value is less than or equal to the provided value. |
| `le_expr` | [`Float_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float_Expr) | Match if field value is less than or equal to the result of the provided server value expression. |

### input Float_ListFilter

Query filter criteria for [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) scalar fields.

| Field | Type | Description |
|---|---|---|
| `includes` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if list field contains the provided value as a member. |
| `excludes` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if list field does not contain the provided value as a member. |
| `includesAll` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if list field contains all of the provided values as members. |
| `excludesAll` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Match if list field does not contain any of the provided values as members. |

### input Float_ListUpdate

Update input of a [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Append the provided list of values to the existing list. |
| `prepend` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Prepend the provided list of values to the existing list. |
| `add` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Append values that do not already exist to the list. |
| `remove` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Remove all occurrences of each value from the list. |

### input Float_Update

Update input of a [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) value. Only one of `inc` or `dec` may be specified.

| Field | Type | Description |
|---|---|---|
| `inc` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Increment the field by a provided value. |
| `dec` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | Decrement the field by a provided value. |

### input Int64_Filter

Query filter criteria for [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) scalar fields.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | When true, match if field `IS NULL`. When false, match if field is `NOT NULL`. |
| `eq` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if field is exactly equal to provided value. |
| `eq_expr` | [`Int64_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64_Expr) | Match if field is exactly equal to the result of the provided server value expression. |
| `ne` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if field is not equal to provided value. |
| `ne_expr` | [`Int64_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64_Expr) | Match if field is not equal to the result of the provided server value expression. |
| `in` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if field value is among the provided list of values. |
| `nin` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if field value is not among the provided list of values. |
| `gt` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if field value is greater than the provided value. |
| `gt_expr` | [`Int64_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64_Expr) | Match if field value is greater than the result of the provided server value expression. |
| `ge` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if field value is greater than or equal to the provided value. |
| `ge_expr` | [`Int64_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64_Expr) | Match if field value is greater than or equal to the result of the provided server value expression. |
| `lt` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if field value is less than the provided value. |
| `lt_expr` | [`Int64_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64_Expr) | Match if field value is less than the result of the provided server value expression. |
| `le` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if field value is less than or equal to the provided value. |
| `le_expr` | [`Int64_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64_Expr) | Match if field value is less than or equal to the result of the provided server value expression. |

### input Int64_ListFilter

Query filter criteria for [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) scalar fields.

| Field | Type | Description |
|---|---|---|
| `includes` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if list field contains the provided value as a member. |
| `excludes` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if list field does not contain the provided value as a member. |
| `includesAll` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if list field contains all of the provided values as members. |
| `excludesAll` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Match if list field does not contain any of the provided values as members. |

### input Int64_ListUpdate

Update input of an [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Append the provided list of values to the existing list. |
| `prepend` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Prepend the provided list of values to the existing list. |
| `add` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Append values that do not already exist to the list. |
| `remove` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Remove all occurrences of each value from the list. |

### input Int64_Update

Update input of an [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) value. Only one of `inc` or `dec` may be specified.

| Field | Type | Description |
|---|---|---|
| `inc` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Increment the field by a provided value. |
| `dec` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | Decrement the field by a provided value. |

### input Int_Filter

Query filter criteria for [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) scalar fields.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | When true, match if field `IS NULL`. When false, match if field is `NOT NULL`. |
| `eq` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if field is exactly equal to provided value. |
| `eq_expr` | [`Int_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int_Expr) | Match if field is exactly equal to the result of the provided server value expression. |
| `ne` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if field is not equal to provided value. |
| `ne_expr` | [`Int_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int_Expr) | Match if field is not equal to the result of the provided server value expression. |
| `in` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if field value is among the provided list of values. |
| `nin` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if field value is not among the provided list of values. |
| `gt` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if field value is greater than the provided value. |
| `gt_expr` | [`Int_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int_Expr) | Match if field value is greater than the result of the provided server value expression. |
| `ge` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if field value is greater than or equal to the provided value. |
| `ge_expr` | [`Int_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int_Expr) | Match if field value is greater than or equal to the result of the provided server value expression. |
| `lt` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if field value is less than the provided value. |
| `lt_expr` | [`Int_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int_Expr) | Match if field value is less than the result of the provided server value expression. |
| `le` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if field value is less than or equal to the provided value. |
| `le_expr` | [`Int_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int_Expr) | Match if field value is less than or equal to the result of the provided server value expression. |

### input Int_ListFilter

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

| Field | Type | Description |
|---|---|---|
| `includes` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if list field contains the provided value as a member. |
| `excludes` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if list field does not contain the provided value as a member. |
| `includesAll` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if list field contains all of the provided values as members. |
| `excludesAll` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Match if list field does not contain any of the provided values as members. |

### input Int_ListUpdate

Update input of an [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Append the provided list of values to the existing list. |
| `prepend` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Prepend the provided list of values to the existing list. |
| `add` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Append values that do not already exist to the list. |
| `remove` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Remove all occurrences of each value from the list. |

### input Int_Update

Update input of an [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) value. Only one of `inc` or `dec` may be specified.

| Field | Type | Description |
|---|---|---|
| `inc` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Increment the field by a provided value. |
| `dec` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | Decrement the field by a provided value. |

### input OnMutationExecuted_Event

Defines the mutation events that will trigger the query to refresh.

| Field | Type | Description |
|---|---|---|
| `operation` | [`String!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | The name of the mutation. |
| `condition` | [`Boolean_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean_Expr) | Additional conditions for a mutation event to trigger refresh. |

### input String_Filter

Query filter criteria for [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) scalar fields.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | When true, match if field `IS NULL`. When false, match if field is `NOT NULL`. |
| `eq` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field is exactly equal to provided value. |
| `eq_expr` | [`String_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String_Expr) | Match if field is exactly equal to the result of the provided server value expression. Currently only `auth.uid` is supported as an expression. |
| `ne` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field is not equal to provided value. |
| `ne_expr` | [`String_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String_Expr) | Match if field is not equal to the result of the provided server value expression. Currently only `auth.uid` is supported as an expression. |
| `in` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value is among the provided list of values. |
| `nin` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value is not among the provided list of values. |
| `gt` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value is greater than the provided value. |
| `ge` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value is greater than or equal to the provided value. |
| `lt` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value is less than the provided value. |
| `le` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value is less than or equal to the provided value. |
| `contains` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value contains the provided value as a substring. Equivalent to `LIKE '%value%'` |
| `startsWith` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value starts with the provided value. Equivalent to `LIKE 'value%'` |
| `endsWith` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if field value ends with the provided value. Equivalent to `LIKE '%value'` |
| `pattern` | [`String_Pattern`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_Pattern) | Match based on the provided pattern. |

### input String_ListFilter

Query filter criteris for [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) scalar fields.

| Field | Type | Description |
|---|---|---|
| `includes` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if list field contains the provided value as a member. |
| `excludes` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if list field does not contain the provided value as a member. |
| `includesAll` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if list field contains all of the provided values as members. |
| `excludesAll` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match if list field does not contain any of the provided values as members. |

### input String_ListUpdate

Update input of a [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Append the provided values to the existing list. |
| `prepend` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Prepend the provided values to the existing list. |
| `add` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Append values that do not already exist to the list. |
| `remove` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Remove all occurrences of each value from the list. |

### input String_Pattern

| Field | Type | Description |
|---|---|---|
| `like` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match using LIKE semantics (https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-LIKE) |
| `regex` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | Match against a POSIX regular expression. |
| `ignoreCase` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | If true, match patterns case-insensitively. |

### input Timestamp_Duration

| Field | Type | Description |
|---|---|---|
| `milliseconds` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of milliseconds for the duration. |
| `seconds` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of seconds for the duration. |
| `minutes` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of minutes for the duration. |
| `hours` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of hours for the duration. |
| `days` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of days for the duration. |
| `weeks` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of weeks for the duration. |
| `months` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of months for the duration. |
| `years` | [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | The number of years for the duration. |

### input Timestamp_Filter

Conditions on a [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) value.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if the field `IS NULL`. |
| `eq` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the field is exactly equal to the provided value. |
| `eq_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | Match if the field equals the provided CEL expression. |
| `eq_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | Match if the field equals the provided relative time. |
| `ne` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the field is not equal to the provided value. |
| `ne_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | Match if the field is not equal to the provided CEL expression. |
| `ne_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | Match if the field is not equal to the provided relative time. |
| `in` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the field value is among the provided list of values. |
| `nin` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the field value is not among the provided list of values. |
| `gt` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the field value is greater than the provided value. |
| `gt_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | Match if the field value is greater than the provided CEL expression. |
| `gt_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | Match if the field value is greater than the provided relative time. |
| `ge` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the field value is greater than or equal to the provided value. |
| `ge_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | Match if the field value is greater than or equal to the provided CEL expression. |
| `ge_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | Match if the field value is greater than or equal to the provided relative time. |
| `lt` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the field value is less than the provided value. |
| `lt_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | Match if the field value is less than the provided CEL expression. |
| `lt_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | Match if the field value is less than the provided relative time. |
| `le` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the field value is less than or equal to the provided value. |
| `le_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | Match if the field value is less than or equal to the provided CEL expression. |
| `le_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | Match if the field value is less than or equal to the provided relative time. |

### input Timestamp_ListFilter

Conditions on a [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) list.

| Field | Type | Description |
|---|---|---|
| `includes` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the list contains the provided timestamp. |
| `includes_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | Match if the list contains the provided timestamp CEL expression. |
| `includes_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | Match if the list contains the provided relative timestamp. |
| `excludes` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the list does not contain the provided timestamp. |
| `excludes_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | Match if the list does not contain the provided timestamp CEL expression. |
| `excludes_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | Match if the list does not contain the provided relative timestamp. |
| `includesAll` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the list contains all the provided timestamps. |
| `excludesAll` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Match if the list contains none of the provided timestamps. |

### input Timestamp_ListUpdate

Update input of an [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Append the provided [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) values to the existing list. |
| `prepend` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Prepend the provided [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) values to the existing list. |
| `add` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Append any [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) values that do not already exist to the list. |
| `remove` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | Remove all occurrences of each [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) from the list. |

### input Timestamp_Relative

A runtime-calculated [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) value relative to `now` or `at`.

| Field | Type | Description |
|---|---|---|
| `now` | [`True`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#True) | Match for the current time. |
| `at` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | A specific timestamp for matching. |
| `add` | [`Timestamp_Duration`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Duration) | Add the provided duration to the base timestamp. |
| `sub` | [`Timestamp_Duration`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Duration) | Subtract the provided duration from the base timestamp. |
| `truncateTo` | [`Timestamp_Interval`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#Timestamp_Interval) | Truncate the timestamp to the provided interval. |

### input Timestamp_Update

Update input of a [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) value. Only one of `inc` or `dec` may be specified.

| Field | Type | Description |
|---|---|---|
| `inc` | [`Timestamp_Duration`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Duration) | Increment the field by a provided duration. |
| `dec` | [`Timestamp_Duration`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Duration) | Decrement the field by a provided duration. |

### input UUID_Filter

Query filter criteria for [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) scalar fields.

| Field | Type | Description |
|---|---|---|
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | When true, match if field `IS NULL`. When false, match if field is `NOT NULL`. |
| `eq` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Match if field is exactly equal to provided value. |
| `eq_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | Match if field is exactly equal to the result of the provided server value expression. |
| `ne` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Match if field is not equal to provided value. |
| `ne_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | Match if field is not equal to the result of the provided server value expression. |
| `in` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Match if field value is among the provided list of values. |
| `nin` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Match if field value is not among the provided list of values. |

### input UUID_ListFilter

Query filter criteris for [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) scalar fields.

| Field | Type | Description |
|---|---|---|
| `includes` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Match if list field contains the provided value as a member. |
| `excludes` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Match if list field does not contain the provided value as a member. |
| `includesAll` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Match if list field contains all of the provided values as members. |
| `excludesAll` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Match if list field does not contain any of the provided values as members. |

### input UUID_ListUpdate

Update input of an [`ID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#ID) list value. Only one of `append`, `prepend`, `add`, or `remove` may be specified.

| Field | Type | Description |
|---|---|---|
| `append` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Append the provided UUIDs to the existing list. |
| `prepend` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Prepend the provided UUIDs to the existing list. |
| `add` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Append values that do not already exist to the list. |
| `remove` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | Remove all occurrences of each value from the list. |

### input Vector_Embed

Create a vector embedding of text using the given model on Vertex AI.

Cloud SQL for Postgresql natively integrates with [Vertex AI Text embeddings API](https://cloud.google.com/vertex-ai/generative-ai/docs/model-reference/text-embeddings-api)
to effectively generate text embeddings.

If you use [](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector)[`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) in your schema, Firebase SQL Connect automatically installs
[`pgvector`](https://github.com/pgvector/pgvector) and [`google_ml_integration`](https://cloud.google.com/sql/docs/postgres/integrate-cloud-sql-with-vertex-ai)
Postgres extensions in your Cloud SQL database.

Given a Post table with a [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) embedding field.

```graphql
type Post @table {
  content: String!
  contentEmbedding: Vector @col(size:768)
}
```

NOTE: All natively supported [`Vector_Embed_Model`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector_Embed_Model) generates vector of length `768`.

###### Example: Insert embedding

```graphql
mutation CreatePost($content: String!) {
  post_insert(data: {
    content: $content,
    contentEmbedding_embed: {model: "textembedding-gecko@003", text: $content},
  })
}
```

###### Example: Vector similarity Search

```graphql
query SearchPost($query: String!) {
  posts_contentEmbedding_similarity(compare_embed: {model: "textembedding-gecko@003", text: $query}) {
    id
    content
  }
}
```

| Field | Type | Description |
|---|---|---|
| `model` | [`Vector_Embed_Model!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector_Embed_Model) | The model to use for vector embedding. Recommend the latest stable model: `textembedding-gecko@003`. |
| `text` | [`String!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | The text to generate the vector embedding from. |

### input Vector_Filter

Conditions on a Vector value.

| Field | Type | Description |
|---|---|---|
| `eq` | [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | Match if the field is exactly equal to the provided vector. |
| `ne` | [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | Match if the field is not equal to the provided vector. |
| `in` | [`[Vector!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | Match if the field value is among the provided list of vectors. |
| `nin` | [`[Vector!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | Match if the field value is not among the provided list of vectors. |
| `isNull` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Match if the field is `NULL`. |

### input Vector_ListFilter

| Field | Type | Description |
|---|---|---|
| `includes` | [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | Match if the list includes the supplied vector. |
| `excludes` | [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | Match if the list does not include the supplied vector. |
| `includesAll` | [`[Vector!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | Match if the list contains all the provided vectors. |
| `excludesAll` | [`[Vector!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | Match if the list contains none of the provided vectors. |

## SQL Connect Generated

### input MainTable_Data

✨ Generated data input type for table 'MainTable'. It includes all necessary fields for creating or upserting rows into table.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `id_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `id` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `anyArray` | [`[Any!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyArray` of type [`[Any]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `anyArray_update` | [`[Any_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_ListUpdate) | ✨ `_update` server value variant of `anyArray` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyArray` of type [`[Any]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any)) |
| `anyField` | [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `anyField_expr` | [`Any_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any_Expr) | ✨ `_expr` server value variant of `anyField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any)) |
| `booleanArray` | [`[Boolean!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanArray` of type [`[Boolean]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) |
| `booleanArray_update` | [`[Boolean_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Boolean_ListUpdate) | ✨ `_update` server value variant of `booleanArray` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanArray` of type [`[Boolean]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean)) |
| `booleanField` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanField` of type [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) |
| `booleanField_expr` | [`Boolean_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean_Expr) | ✨ `_expr` server value variant of `booleanField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanField` of type [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean)) |
| `dateArray` | [`[Date!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateArray` of type [`[Date]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `dateArray_update` | [`[Date_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_ListUpdate) | ✨ `_update` server value variant of `dateArray` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateArray` of type [`[Date]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date)) |
| `dateField` | [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `dateField_expr` | [`Date_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date_Expr) | ✨ `_expr` server value variant of `dateField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date)) |
| `dateField_date` | [`Date_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Relative) | ✨ `_date` server value variant of `dateField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date)) |
| `dateField_update` | [`[Date_Update!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Update) | ✨ `_update` server value variant of `dateField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date)) |
| `floatArray` | [`[Float!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatArray` of type [`[Float]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `floatArray_update` | [`[Float_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_ListUpdate) | ✨ `_update` server value variant of `floatArray` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatArray` of type [`[Float]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float)) |
| `floatField` | [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `floatField_expr` | [`Float_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float_Expr) | ✨ `_expr` server value variant of `floatField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float)) |
| `floatField_update` | [`[Float_Update!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_Update) | ✨ `_update` server value variant of `floatField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float)) |
| `int64Array` | [`[Int64!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Array` of type [`[Int64]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `int64Array_update` | [`[Int64_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int64_ListUpdate) | ✨ `_update` server value variant of `int64Array` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Array` of type [`[Int64]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64)) |
| `int64Field` | [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `int64Field_expr` | [`Int64_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64_Expr) | ✨ `_expr` server value variant of `int64Field` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64)) |
| `int64Field_update` | [`[Int64_Update!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int64_Update) | ✨ `_update` server value variant of `int64Field` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64)) |
| `intArray` | [`[Int!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intArray` of type [`[Int]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `intArray_update` | [`[Int_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_ListUpdate) | ✨ `_update` server value variant of `intArray` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intArray` of type [`[Int]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)) |
| `intField` | [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `intField_expr` | [`Int_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int_Expr) | ✨ `_expr` server value variant of `intField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)) |
| `intField_update` | [`[Int_Update!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Update) | ✨ `_update` server value variant of `intField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int)) |
| `stringArray` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringArray` of type [`[String]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringArray_update` | [`[String_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListUpdate) | ✨ `_update` server value variant of `stringArray` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringArray` of type [`[String]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String)) |
| `stringField` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringField` of type [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringField_expr` | [`String_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String_Expr) | ✨ `_expr` server value variant of `stringField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringField` of type [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String)) |
| `timestampArray` | [`[Timestamp!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampArray` of type [`[Timestamp]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |
| `timestampArray_update` | [`[Timestamp_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_ListUpdate) | ✨ `_update` server value variant of `timestampArray` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampArray` of type [`[Timestamp]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp)) |
| `timestampField` | [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |
| `timestampField_expr` | [`Timestamp_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp_Expr) | ✨ `_expr` server value variant of `timestampField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp)) |
| `timestampField_time` | [`Timestamp_Relative`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Relative) | ✨ `_time` server value variant of `timestampField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp)) |
| `timestampField_update` | [`[Timestamp_Update!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Update) | ✨ `_update` server value variant of `timestampField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp)) |
| `uuidArray` | [`[UUID!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidArray` of type [`[UUID]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `uuidArray_update` | [`[UUID_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_ListUpdate) | ✨ `_update` server value variant of `uuidArray` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidArray` of type [`[UUID]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `uuidField` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidField` of type [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `uuidField_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `uuidField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidField` of type [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `vectorField` | [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`vectorField` of type [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) |
| `vectorField_embed` | [`Vector_Embed`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Vector_Embed) | ✨ `_embed` server value variant of `vectorField` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`vectorField` of type [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector)) |
| `manyToManyJoinTables_on_left` | [`[ManyToManyJoinTable_Data!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Data) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`manyToManyJoinTables_on_left` of type [`[ManyToManyJoinTable!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) |
| `manyToManyJoinTables_on_right` | [`[ManyToManyJoinTable_Data!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Data) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`manyToManyJoinTables_on_right` of type [`[ManyToManyJoinTable!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) |
| `manyToOneExamples_on_main` | [`[ManyToOneExample_Data!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Data) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`manyToOneExamples_on_main` of type [`[ManyToOneExample!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) |
| `oneToOneExample_on_main` | [`OneToOneExample_Data`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Data) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`oneToOneExample_on_main` of type [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) |

### input MainTable_Filter

✨ Generated filter input type for table 'MainTable'. This input allows filtering objects using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[MainTable_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | Apply multiple filter conditions using `AND` logic. |
| `_or` | [`[MainTable_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | Apply multiple filter conditions using `OR` logic. |
| `_not` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | Negate the result of the provided filter condition. |
| `id` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `anyArray` | [`Any_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyArray` of type [`[Any]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `anyField` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `booleanArray` | [`Boolean_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Boolean_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanArray` of type [`[Boolean]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) |
| `booleanField` | [`Boolean_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Boolean_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanField` of type [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) |
| `dateArray` | [`Date_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateArray` of type [`[Date]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `dateField` | [`Date_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `floatArray` | [`Float_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatArray` of type [`[Float]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `floatField` | [`Float_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Array` | [`Int64_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int64_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Array` of type [`[Int64]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `int64Field` | [`Int64_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int64_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `intArray` | [`Int_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intArray` of type [`[Int]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `intField` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `stringArray` | [`String_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringArray` of type [`[String]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringField` | [`String_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringField` of type [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `timestampArray` | [`Timestamp_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampArray` of type [`[Timestamp]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |
| `timestampField` | [`Timestamp_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |
| `uuidArray` | [`UUID_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidArray` of type [`[UUID]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `uuidField` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidField` of type [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `vectorField` | [`Vector_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Vector_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`vectorField` of type [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) |
| `manyToManyJoinTables_on_left` | [`ManyToManyJoinTable_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`manyToManyJoinTables_on_left` of type [`[ManyToManyJoinTable!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) |
| `manyToManyJoinTables_on_right` | [`ManyToManyJoinTable_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`manyToManyJoinTables_on_right` of type [`[ManyToManyJoinTable!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable) |
| `manyToOneExamples_on_main` | [`ManyToOneExample_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`manyToOneExamples_on_main` of type [`[ManyToOneExample!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample) |
| `oneToOneExample_on_main` | [`OneToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`oneToOneExample_on_main` of type [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample) |
| `mainTables_via_ManyToManyJoinTable_on_left` | [`MainTable_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`mainTables_via_ManyToManyJoinTable_on_left` of type [`[MainTable!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `mainTables_via_ManyToManyJoinTable_on_right` | [`MainTable_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_ListFilter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`mainTables_via_ManyToManyJoinTable_on_right` of type [`[MainTable!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |

### input MainTable_FirstRow

✨ Generated first-row input type for table 'MainTable'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.

| Field | Type | Description |
|---|---|---|
| `where` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | Filters rows based on the specified conditions. |
| `orderBy` | [`[MainTable_Order!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Order) | Order the result by the specified fields. |

### input MainTable_Having

✨ Generated having input type for table 'MainTable'. This input allows you to filter groups during aggregate queries using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[MainTable_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Having) | Apply multiple Having conditions using `AND` logic. |
| `_or` | [`[MainTable_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Having) | Apply multiple Having conditions using `OR` logic. |
| `_not` | [`MainTable_Having`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Having) | Negate the result of the provided Having condition. |
| `_distinct` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Whether to apply DISTINCT to the aggregate function. |
| `_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `anyField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `booleanField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `dateField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `floatField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `id_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`id_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `int64Field_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `intField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `stringField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `timestampField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `uuidField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `vectorField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`vectorField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `floatField_sum` | [`Float_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_sum` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field_sum` | [`Int64_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int64_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_sum` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `intField_sum` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_sum` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `floatField_avg` | [`Float_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_avg` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field_avg` | [`Float_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_avg` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `intField_avg` | [`Float_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_avg` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `anyField_min` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField_min` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `dateField_min` | [`Date_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField_min` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `floatField_min` | [`Float_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_min` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field_min` | [`Int64_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int64_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_min` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `intField_min` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_min` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `timestampField_min` | [`Timestamp_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField_min` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |
| `anyField_max` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField_max` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `dateField_max` | [`Date_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Date_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField_max` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `floatField_max` | [`Float_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Float_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_max` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field_max` | [`Int64_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int64_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_max` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `intField_max` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_max` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `timestampField_max` | [`Timestamp_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Timestamp_Filter) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField_max` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |

### input MainTable_Key

✨ Generated key input type for table 'MainTable'. It represents the primary key fields used to uniquely identify a row in the table.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `id_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `id` (✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |

### input MainTable_ListFilter

✨ Generated list filter input type for table 'MainTable'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.

| Field | Type | Description |
|---|---|---|
| `count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | The desired number of objects that match the condition (defaults to at least one). |
| `exist` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | Condition of the related objects to filter for. |

### input MainTable_Order

✨ Generated order input type for table 'MainTable'. This input defines the sorting order of rows in query results based on one or more fields.

| Field | Type | Description |
|---|---|---|
| `id` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `anyField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `booleanField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanField` of type [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) |
| `dateField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `floatField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `intField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `stringField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringField` of type [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `timestampField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |
| `uuidField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidField` of type [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `vectorField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`vectorField` of type [`Vector`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Vector) |
| `_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `anyField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `booleanField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`booleanField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `dateField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `floatField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `id_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`id_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `int64Field_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `intField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `stringField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`stringField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `timestampField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `uuidField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`uuidField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `vectorField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`vectorField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `floatField_sum` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_sum` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field_sum` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_sum` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `intField_sum` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_sum` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `floatField_avg` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_avg` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field_avg` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_avg` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `intField_avg` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_avg` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `anyField_min` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField_min` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `dateField_min` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField_min` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `floatField_min` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_min` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field_min` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_min` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `intField_min` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_min` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `timestampField_min` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField_min` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |
| `anyField_max` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`anyField_max` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `dateField_max` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`dateField_max` of type [`Date`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Date) |
| `floatField_max` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`floatField_max` of type [`Float`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Float) |
| `int64Field_max` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`int64Field_max` of type [`Int64`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int64) |
| `intField_max` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`intField_max` of type [`Int`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `timestampField_max` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`MainTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable).`timestampField_max` of type [`Timestamp`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Timestamp) |

### input ManyToManyJoinTable_Data

✨ Generated data input type for table 'ManyToManyJoinTable'. It includes all necessary fields for creating or upserting rows into table.

| Field | Type | Description |
|---|---|---|
| `leftId` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`leftId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `leftId_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `leftId` (✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`leftId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `rightId` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`rightId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `rightId_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `rightId` (✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`rightId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `left` | [`MainTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Key) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`left` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `right` | [`MainTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Key) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`right` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |

### input ManyToManyJoinTable_Filter

✨ Generated filter input type for table 'ManyToManyJoinTable'. This input allows filtering objects using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[ManyToManyJoinTable_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Filter) | Apply multiple filter conditions using `AND` logic. |
| `_or` | [`[ManyToManyJoinTable_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Filter) | Apply multiple filter conditions using `OR` logic. |
| `_not` | [`ManyToManyJoinTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Filter) | Negate the result of the provided filter condition. |
| `leftId` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`leftId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `rightId` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`rightId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `left` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`left` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `right` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`right` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |

### input ManyToManyJoinTable_FirstRow

✨ Generated first-row input type for table 'ManyToManyJoinTable'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.

| Field | Type | Description |
|---|---|---|
| `where` | [`ManyToManyJoinTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Filter) | Filters rows based on the specified conditions. |
| `orderBy` | [`[ManyToManyJoinTable_Order!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Order) | Order the result by the specified fields. |

### input ManyToManyJoinTable_Having

✨ Generated having input type for table 'ManyToManyJoinTable'. This input allows you to filter groups during aggregate queries using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[ManyToManyJoinTable_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Having) | Apply multiple Having conditions using `AND` logic. |
| `_or` | [`[ManyToManyJoinTable_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Having) | Apply multiple Having conditions using `OR` logic. |
| `_not` | [`ManyToManyJoinTable_Having`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Having) | Negate the result of the provided Having condition. |
| `_distinct` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Whether to apply DISTINCT to the aggregate function. |
| `_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `leftId_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`leftId_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `rightId_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`rightId_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |

### input ManyToManyJoinTable_Key

✨ Generated key input type for table 'ManyToManyJoinTable'. It represents the primary key fields used to uniquely identify a row in the table.

| Field | Type | Description |
|---|---|---|
| `leftId` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`leftId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `leftId_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `leftId` (✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`leftId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `rightId` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`rightId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `rightId_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `rightId` (✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`rightId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |

### input ManyToManyJoinTable_ListFilter

✨ Generated list filter input type for table 'ManyToManyJoinTable'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.

| Field | Type | Description |
|---|---|---|
| `count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | The desired number of objects that match the condition (defaults to at least one). |
| `exist` | [`ManyToManyJoinTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToManyJoinTable_Filter) | Condition of the related objects to filter for. |

### input ManyToManyJoinTable_Order

✨ Generated order input type for table 'ManyToManyJoinTable'. This input defines the sorting order of rows in query results based on one or more fields.

| Field | Type | Description |
|---|---|---|
| `leftId` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`leftId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `rightId` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`rightId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `left` | [`MainTable_Order`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Order) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`left` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `right` | [`MainTable_Order`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Order) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`right` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `leftId_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`leftId_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `rightId_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToManyJoinTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToManyJoinTable).`rightId_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |

### input ManyToOneExample_Data

✨ Generated data input type for table 'ManyToOneExample'. It includes all necessary fields for creating or upserting rows into table.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `id_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `id` (✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `mainId` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`mainId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `mainId_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `mainId` (✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`mainId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `main` | [`MainTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Key) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`main` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `someField` | [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `someField_expr` | [`Any_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any_Expr) | ✨ `_expr` server value variant of `someField` (✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any)) |

### input ManyToOneExample_Filter

✨ Generated filter input type for table 'ManyToOneExample'. This input allows filtering objects using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[ManyToOneExample_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Filter) | Apply multiple filter conditions using `AND` logic. |
| `_or` | [`[ManyToOneExample_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Filter) | Apply multiple filter conditions using `OR` logic. |
| `_not` | [`ManyToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Filter) | Negate the result of the provided filter condition. |
| `id` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `mainId` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`mainId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `main` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`main` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `someField` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |

### input ManyToOneExample_FirstRow

✨ Generated first-row input type for table 'ManyToOneExample'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.

| Field | Type | Description |
|---|---|---|
| `where` | [`ManyToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Filter) | Filters rows based on the specified conditions. |
| `orderBy` | [`[ManyToOneExample_Order!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Order) | Order the result by the specified fields. |

### input ManyToOneExample_Having

✨ Generated having input type for table 'ManyToOneExample'. This input allows you to filter groups during aggregate queries using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[ManyToOneExample_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Having) | Apply multiple Having conditions using `AND` logic. |
| `_or` | [`[ManyToOneExample_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Having) | Apply multiple Having conditions using `OR` logic. |
| `_not` | [`ManyToOneExample_Having`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Having) | Negate the result of the provided Having condition. |
| `_distinct` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Whether to apply DISTINCT to the aggregate function. |
| `_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `id_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`id_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `mainId_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`mainId_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `someField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `someField_min` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField_min` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `someField_max` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField_max` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |

### input ManyToOneExample_Key

✨ Generated key input type for table 'ManyToOneExample'. It represents the primary key fields used to uniquely identify a row in the table.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `id_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `id` (✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |

### input ManyToOneExample_ListFilter

✨ Generated list filter input type for table 'ManyToOneExample'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.

| Field | Type | Description |
|---|---|---|
| `count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | The desired number of objects that match the condition (defaults to at least one). |
| `exist` | [`ManyToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#ManyToOneExample_Filter) | Condition of the related objects to filter for. |

### input ManyToOneExample_Order

✨ Generated order input type for table 'ManyToOneExample'. This input defines the sorting order of rows in query results based on one or more fields.

| Field | Type | Description |
|---|---|---|
| `id` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `mainId` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`mainId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `main` | [`MainTable_Order`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Order) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`main` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `someField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `id_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`id_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `mainId_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`mainId_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `someField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `someField_min` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField_min` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `someField_max` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`ManyToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#ManyToOneExample).`someField_max` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |

### input OneToOneExample_Data

✨ Generated data input type for table 'OneToOneExample'. It includes all necessary fields for creating or upserting rows into table.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `id_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `id` (✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `mainId` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`mainId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `mainId_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `mainId` (✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`mainId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `main` | [`MainTable_Key`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Key) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`main` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `someField` | [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `someField_expr` | [`Any_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any_Expr) | ✨ `_expr` server value variant of `someField` (✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any)) |

### input OneToOneExample_Filter

✨ Generated filter input type for table 'OneToOneExample'. This input allows filtering objects using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[OneToOneExample_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Filter) | Apply multiple filter conditions using `AND` logic. |
| `_or` | [`[OneToOneExample_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Filter) | Apply multiple filter conditions using `OR` logic. |
| `_not` | [`OneToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Filter) | Negate the result of the provided filter condition. |
| `id` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `mainId` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`mainId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `main` | [`MainTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`main` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `someField` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |

### input OneToOneExample_FirstRow

✨ Generated first-row input type for table 'OneToOneExample'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.

| Field | Type | Description |
|---|---|---|
| `where` | [`OneToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Filter) | Filters rows based on the specified conditions. |
| `orderBy` | [`[OneToOneExample_Order!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Order) | Order the result by the specified fields. |

### input OneToOneExample_Having

✨ Generated having input type for table 'OneToOneExample'. This input allows you to filter groups during aggregate queries using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[OneToOneExample_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Having) | Apply multiple Having conditions using `AND` logic. |
| `_or` | [`[OneToOneExample_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Having) | Apply multiple Having conditions using `OR` logic. |
| `_not` | [`OneToOneExample_Having`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Having) | Negate the result of the provided Having condition. |
| `_distinct` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Whether to apply DISTINCT to the aggregate function. |
| `_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `id_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`id_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `mainId_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`mainId_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `someField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `someField_min` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField_min` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `someField_max` | [`Any_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Any_Filter) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField_max` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |

### input OneToOneExample_Key

✨ Generated key input type for table 'OneToOneExample'. It represents the primary key fields used to uniquely identify a row in the table.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `id_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `id` (✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |

### input OneToOneExample_ListFilter

✨ Generated list filter input type for table 'OneToOneExample'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.

| Field | Type | Description |
|---|---|---|
| `count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | The desired number of objects that match the condition (defaults to at least one). |
| `exist` | [`OneToOneExample_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#OneToOneExample_Filter) | Condition of the related objects to filter for. |

### input OneToOneExample_Order

✨ Generated order input type for table 'OneToOneExample'. This input defines the sorting order of rows in query results based on one or more fields.

| Field | Type | Description |
|---|---|---|
| `id` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `mainId` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`mainId` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `main` | [`MainTable_Order`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#MainTable_Order) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`main` of type [`MainTable!`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#MainTable) |
| `someField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `id_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`id_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `mainId_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`mainId_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `someField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `someField_min` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField_min` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |
| `someField_max` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`OneToOneExample`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#OneToOneExample).`someField_max` of type [`Any`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Any) |

### input StringTable_Data

✨ Generated data input type for table 'StringTable'. It includes all necessary fields for creating or upserting rows into table.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `id_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `id` (✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |
| `nonNullStringArray` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringArray` of type [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `nonNullStringArray_update` | [`[String_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListUpdate) | ✨ `_update` server value variant of `nonNullStringArray` (✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringArray` of type [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String)) |
| `nonNullStringField` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringField` of type [`String!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `nonNullStringField_expr` | [`String_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String_Expr) | ✨ `_expr` server value variant of `nonNullStringField` (✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringField` of type [`String!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String)) |
| `nonNullStringNonnullArray` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringNonnullArray` of type [`[String!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `nonNullStringNonnullArray_update` | [`[String_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListUpdate) | ✨ `_update` server value variant of `nonNullStringNonnullArray` (✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringNonnullArray` of type [`[String!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String)) |
| `stringArray` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringArray` of type [`[String]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringArray_update` | [`[String_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListUpdate) | ✨ `_update` server value variant of `stringArray` (✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringArray` of type [`[String]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String)) |
| `stringField` | [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringField` of type [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringField_expr` | [`String_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String_Expr) | ✨ `_expr` server value variant of `stringField` (✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringField` of type [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String)) |
| `stringNonnullArray` | [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringNonnullArray` of type [`[String]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringNonnullArray_update` | [`[String_ListUpdate!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListUpdate) | ✨ `_update` server value variant of `stringNonnullArray` (✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringNonnullArray` of type [`[String]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String)) |

### input StringTable_Filter

✨ Generated filter input type for table 'StringTable'. This input allows filtering objects using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[StringTable_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Filter) | Apply multiple filter conditions using `AND` logic. |
| `_or` | [`[StringTable_Filter!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Filter) | Apply multiple filter conditions using `OR` logic. |
| `_not` | [`StringTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Filter) | Negate the result of the provided filter condition. |
| `id` | [`UUID_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#UUID_Filter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `nonNullStringArray` | [`String_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListFilter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringArray` of type [`[String!]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `nonNullStringField` | [`String_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_Filter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringField` of type [`String!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `nonNullStringNonnullArray` | [`String_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListFilter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringNonnullArray` of type [`[String!]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringArray` | [`String_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListFilter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringArray` of type [`[String]`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringField` | [`String_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_Filter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringField` of type [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringNonnullArray` | [`String_ListFilter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#String_ListFilter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringNonnullArray` of type [`[String]!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |

### input StringTable_FirstRow

✨ Generated first-row input type for table 'StringTable'. This input selects the first row matching the filter criteria, ordered according to the specified conditions.

| Field | Type | Description |
|---|---|---|
| `where` | [`StringTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Filter) | Filters rows based on the specified conditions. |
| `orderBy` | [`[StringTable_Order!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Order) | Order the result by the specified fields. |

### input StringTable_Having

✨ Generated having input type for table 'StringTable'. This input allows you to filter groups during aggregate queries using various conditions. Use `_or`, `_and`, and `_not` to compose complex filters.

| Field | Type | Description |
|---|---|---|
| `_and` | [`[StringTable_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Having) | Apply multiple Having conditions using `AND` logic. |
| `_or` | [`[StringTable_Having!]`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Having) | Apply multiple Having conditions using `OR` logic. |
| `_not` | [`StringTable_Having`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Having) | Negate the result of the provided Having condition. |
| `_distinct` | [`Boolean`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Boolean) | Whether to apply DISTINCT to the aggregate function. |
| `_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `id_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`id_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `nonNullStringField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `stringField_count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |

### input StringTable_Key

✨ Generated key input type for table 'StringTable'. It represents the primary key fields used to uniquely identify a row in the table.

| Field | Type | Description |
|---|---|---|
| `id` | [`UUID`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `id_expr` | [`UUID_Expr`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID_Expr) | ✨ `_expr` server value variant of `id` (✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID)) |

### input StringTable_ListFilter

✨ Generated list filter input type for table 'StringTable'. This input applies filtering logic based on the count or existence of related objects that matches certain criteria.

| Field | Type | Description |
|---|---|---|
| `count` | [`Int_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#Int_Filter) | The desired number of objects that match the condition (defaults to at least one). |
| `exist` | [`StringTable_Filter`](https://firebase.google.com/docs/reference/sql-connect/gql/input_object.md.txt#StringTable_Filter) | Condition of the related objects to filter for. |

### input StringTable_Order

✨ Generated order input type for table 'StringTable'. This input defines the sorting order of rows in query results based on one or more fields.

| Field | Type | Description |
|---|---|---|
| `id` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`id` of type [`UUID!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#UUID) |
| `nonNullStringField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringField` of type [`String!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `stringField` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringField` of type [`String`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#String) |
| `_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `id_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`id_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `nonNullStringField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`nonNullStringField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |
| `stringField_count` | [`OrderDirection`](https://firebase.google.com/docs/reference/sql-connect/gql/enum.md.txt#OrderDirection) | ✨ Generated from Field [`StringTable`](https://firebase.google.com/docs/reference/sql-connect/gql/object.md.txt#StringTable).`stringField_count` of type [`Int!`](https://firebase.google.com/docs/reference/sql-connect/gql/scalar.md.txt#Int) |