Inputs Object Types

This reference doc is generated based on this example schema.

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

Data Connect generates input types to work with built in scalars and developer defined @table types.

Data Connect Defined

input Any_Filter

Query filter criteria for Any scalar fields.

Field Type Description
isNull Boolean When true, match if field IS NULL. When false, match if field is NOT NULL.
eq Any Match if field is exactly equal to provided value.
ne Any Match if field is not equal to provided value.
in [Any!] Match if field value is among the provided list of values.
nin [Any!] Match if field value is not among the provided list of values.

input Any_ListFilter

Query filter criteria for [Any!] scalar fields.

Field Type Description
includes Any Match if list field contains the provided value as a member.
excludes Any Match if list field does not contain the provided value as a member.
includesAll [Any!] Match if list field contains all of the provided values as members.
excludesAll [Any!] Match if list field does not contain any of the provided values as members.

input Any_ListUpdate

Update input of an Any list value.

Field Type Description
append [Any!] Append the provided list of values to the existing list.
prepend [Any!] Prepend the provided list of values to the existing list.

input Boolean_Filter

Query filter criteria for Boolean scalar fields.

Field Type Description
isNull Boolean When true, match if field IS NULL. When false, match if field is NOT NULL.
eq Boolean Match if field is exactly equal to provided value.
eq_expr Boolean_Expr Match if field is equal to the result of the provided expression.
ne Boolean Match if field is not equal to provided value.
ne_expr Boolean_Expr Match if field does not match the result of the provided expression.
in [Boolean!] Match if field value is among the provided list of values.
nin [Boolean!] Match if field value is not among the provided list of values.

input Boolean_ListFilter

Query filter criteria for [Boolean!] scalar fields.

Field Type Description
includes Boolean Match if list field contains the provided value as a member.
excludes Boolean Match if list field does not contain the provided value as a member.
includesAll [Boolean!] Match if list field contains all of the provided values as members.
excludesAll [Boolean!] Match if list field does not contain any of the provided values as members.

input Boolean_ListUpdate

Update input of a Boolean list value.

Field Type Description
append [Boolean!] Append the provided list of values to the existing list.
prepend [Boolean!] Prepend the provided list of values to the existing list.

input Date_Duration

Field Type Description
days Int! The number of days for the duration.
weeks Int! The number of weeks for the duration.
months Int! The number of months for the duration.
years Int! The number of years for the duration.

input Date_Filter

Conditions on a Date value.

Field Type Description
isNull Boolean Match if the field IS NULL.
eq Date Match if the field is exactly equal to the provided value.
eq_expr Date_Expr Match if the field equals the provided CEL expression.
eq_date Date_Relative Match if the field equals the provided relative date.
ne Date Match if the field is not equal to the provided value.
ne_expr Date_Expr Match if the field is not equal to the provided CEL expression.
ne_date Date_Relative Match if the field is not equal to the provided relative date.
in [Date!] Match if the field value is among the provided list of values.
nin [Date!] Match if the field value is not among the provided list of values.
gt Date Match if the field value is greater than the provided value.
gt_expr Date_Expr Match if the field value is greater than the provided CEL expression.
gt_date Date_Relative Match if the field value is greater than the provided relative date.
ge Date Match if the field value is greater than or equal to the provided value.
ge_expr Date_Expr Match if the field value is greater than or equal to the provided CEL expression.
ge_date Date_Relative Match if the field value is greater than or equal to the provided relative date.
lt Date Match if the field value is less than the provided value.
lt_expr Date_Expr Match if the field value is less than the provided CEL expression.
lt_date Date_Relative Match if the field value is less than the provided relative date.
le Date Match if the field value is less than or equal to the provided value.
le_expr Date_Expr Match if the field value is less than or equal to the provided CEL expression.
le_date Date_Relative Match if the field value is less than or equal to the provided relative date.

input Date_ListFilter

Conditions on aDate list.

Field Type Description
includes Date Match if the list contains the provided date.
includes_expr Date_Expr Match if the list contains the provided date CEL expression.
includes_date Date_Relative Match if the list contains the provided relative date.
excludes Date Match if the list does not contain the provided date.
excludes_expr Date_Expr Match if the list does not contain the provided date CEL expression.
excludes_date Date_Relative Match if the list does not contain the provided relative date.
includesAll [Date!] Match if the list contains all the provided dates.
excludesAll [Date!] Match if the list contains none of the provided dates.

input Date_ListUpdate

Update input of a Date list value.

Field Type Description
append [Date!] Append the provided Date values to the existing list.
prepend [Date!] Prepend the provided Date values to the existing list.

input Date_Relative

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

Field Type Description
today True Match for today’s date.
on Date A specific date for matching.
add Date_Duration Add the provided duration to the base date.
sub Date_Duration Subtract the provided duration from the base date.
truncateTo Date_Interval Truncate the date to the provided interval.

input Date_Update

Update input of a Date value.

Field Type Description
inc Date_Duration Increment the field by a provided duration.
dec Date_Duration Decrement the field by a provided duration.

input Float_Filter

Query filter criteria for Float scalar fields.

Field Type Description
isNull Boolean When true, match if field IS NULL. When false, match if field is NOT NULL.
eq Float Match if field is exactly equal to provided value.
eq_expr Float_Expr Match if field is exactly equal to the result of the provided server value expression.
ne Float Match if field is not equal to provided value.
ne_expr Float_Expr Match if field is not equal to the result of the provided server value expression.
in [Float!] Match if field value is among the provided list of values.
nin [Float!] Match if field value is not among the provided list of values.
gt Float Match if field value is greater than the provided value.
gt_expr Float_Expr Match if field value is greater than the result of the provided server value expression.
ge Float Match if field value is greater than or equal to the provided value.
ge_expr Float_Expr Match if field value is greater than or equal to the result of the provided server value expression.
lt Float Match if field value is less than the provided value.
lt_expr Float_Expr Match if field value is less than the result of the provided server value expression.
le Float Match if field value is less than or equal to the provided value.
le_expr 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!] scalar fields.

Field Type Description
includes Float Match if list field contains the provided value as a member.
excludes Float Match if list field does not contain the provided value as a member.
includesAll [Float!] Match if list field contains all of the provided values as members.
excludesAll [Float!] Match if list field does not contain any of the provided values as members.

input Float_ListUpdate

Update input of a Float list value.

Field Type Description
append [Float!] Append the provided list of values to the existing list.
prepend [Float!] Prepend the provided list of values to the existing list.

input Float_Update

Update input of a Float value.

Field Type Description
inc Float Increment the field by a provided value.
dec Float Decrement the field by a provided value.

input Int64_Filter

Query filter criteria for Int64 scalar fields.

Field Type Description
isNull Boolean When true, match if field IS NULL. When false, match if field is NOT NULL.
eq Int64 Match if field is exactly equal to provided value.
eq_expr Int64_Expr Match if field is exactly equal to the result of the provided server value expression.
ne Int64 Match if field is not equal to provided value.
ne_expr Int64_Expr Match if field is not equal to the result of the provided server value expression.
in [Int64!] Match if field value is among the provided list of values.
nin [Int64!] Match if field value is not among the provided list of values.
gt Int64 Match if field value is greater than the provided value.
gt_expr Int64_Expr Match if field value is greater than the result of the provided server value expression.
ge Int64 Match if field value is greater than or equal to the provided value.
ge_expr Int64_Expr Match if field value is greater than or equal to the result of the provided server value expression.
lt Int64 Match if field value is less than the provided value.
lt_expr Int64_Expr Match if field value is less than the result of the provided server value expression.
le Int64 Match if field value is less than or equal to the provided value.
le_expr 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!] scalar fields.

Field Type Description
includes Int64 Match if list field contains the provided value as a member.
excludes Int64 Match if list field does not contain the provided value as a member.
includesAll [Int64!] Match if list field contains all of the provided values as members.
excludesAll [Int64!] Match if list field does not contain any of the provided values as members.

input Int64_ListUpdate

Update input of an Int64 list value.

Field Type Description
append [Int64!] Append the provided list of values to the existing list.
prepend [Int64!] Prepend the provided list of values to the existing list.

input Int64_Update

Update input of an Int64 value.

Field Type Description
inc Int64 Increment the field by a provided value.
dec Int64 Decrement the field by a provided value.

input Int_Filter

Query filter criteria for Int scalar fields.

Field Type Description
isNull Boolean When true, match if field IS NULL. When false, match if field is NOT NULL.
eq Int Match if field is exactly equal to provided value.
eq_expr Int_Expr Match if field is exactly equal to the result of the provided server value expression.
ne Int Match if field is not equal to provided value.
ne_expr Int_Expr Match if field is not equal to the result of the provided server value expression.
in [Int!] Match if field value is among the provided list of values.
nin [Int!] Match if field value is not among the provided list of values.
gt Int Match if field value is greater than the provided value.
gt_expr Int_Expr Match if field value is greater than the result of the provided server value expression.
ge Int Match if field value is greater than or equal to the provided value.
ge_expr Int_Expr Match if field value is greater than or equal to the result of the provided server value expression.
lt Int Match if field value is less than the provided value.
lt_expr Int_Expr Match if field value is less than the result of the provided server value expression.
le Int Match if field value is less than or equal to the provided value.
le_expr 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!] scalar fields.

Field Type Description
includes Int Match if list field contains the provided value as a member.
excludes Int Match if list field does not contain the provided value as a member.
includesAll [Int!] Match if list field contains all of the provided values as members.
excludesAll [Int!] Match if list field does not contain any of the provided values as members.

input Int_ListUpdate

Update input of an Int list value.

Field Type Description
append [Int!] Append the provided list of values to the existing list.
prepend [Int!] Prepend the provided list of values to the existing list.

input Int_Update

Update input of an Int value.

Field Type Description
inc Int Increment the field by a provided value.
dec Int Decrement the field by a provided value.

input String_Filter

Query filter criteria for String scalar fields.

Field Type Description
isNull Boolean When true, match if field IS NULL. When false, match if field is NOT NULL.
eq String Match if field is exactly equal to provided value.
eq_expr 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 Match if field is not equal to provided value.
ne_expr 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!] Match if field value is among the provided list of values.
nin [String!] Match if field value is not among the provided list of values.
gt String Match if field value is greater than the provided value.
ge String Match if field value is greater than or equal to the provided value.
lt String Match if field value is less than the provided value.
le String Match if field value is less than or equal to the provided value.
contains String Match if field value contains the provided value as a substring. Equivalent to LIKE '%value%'
startsWith String Match if field value starts with the provided value. Equivalent to LIKE 'value%'
endsWith String Match if field value ends with the provided value. Equivalent to LIKE '%value'

input String_ListFilter

Query filter criteris for [String!] scalar fields.

Field Type Description
includes String Match if list field contains the provided value as a member.
excludes String Match if list field does not contain the provided value as a member.
includesAll [String!] Match if list field contains all of the provided values as members.
excludesAll [String!] Match if list field does not contain any of the provided values as members.

input String_ListUpdate

Update input of a String list value.

Field Type Description
append [String!] Append the provided values to the existing list.
prepend [String!] Prepend the provided values to the existing list.

input Timestamp_Duration

Field Type Description
milliseconds Int! The number of milliseconds for the duration.
seconds Int! The number of seconds for the duration.
minutes Int! The number of minutes for the duration.
hours Int! The number of hours for the duration.
days Int! The number of days for the duration.
weeks Int! The number of weeks for the duration.
months Int! The number of months for the duration.
years Int! The number of years for the duration.

input Timestamp_Filter

Conditions on a Timestamp value.

Field Type Description
isNull Boolean Match if the field IS NULL.
eq Timestamp Match if the field is exactly equal to the provided value.
eq_expr Timestamp_Expr Match if the field equals the provided CEL expression.
eq_time Timestamp_Relative Match if the field equals the provided relative time.
ne Timestamp Match if the field is not equal to the provided value.
ne_expr Timestamp_Expr Match if the field is not equal to the provided CEL expression.
ne_time Timestamp_Relative Match if the field is not equal to the provided relative time.
in [Timestamp!] Match if the field value is among the provided list of values.
nin [Timestamp!] Match if the field value is not among the provided list of values.
gt Timestamp Match if the field value is greater than the provided value.
gt_expr Timestamp_Expr Match if the field value is greater than the provided CEL expression.
gt_time Timestamp_Relative Match if the field value is greater than the provided relative time.
ge Timestamp Match if the field value is greater than or equal to the provided value.
ge_expr Timestamp_Expr Match if the field value is greater than or equal to the provided CEL expression.
ge_time Timestamp_Relative Match if the field value is greater than or equal to the provided relative time.
lt Timestamp Match if the field value is less than the provided value.
lt_expr Timestamp_Expr Match if the field value is less than the provided CEL expression.
lt_time Timestamp_Relative Match if the field value is less than the provided relative time.
le Timestamp Match if the field value is less than or equal to the provided value.
le_expr Timestamp_Expr Match if the field value is less than or equal to the provided CEL expression.
le_time Timestamp_Relative Match if the field value is less than or equal to the provided relative time.

input Timestamp_ListFilter

Conditions on a Timestamp list.

Field Type Description
includes Timestamp Match if the list contains the provided timestamp.
includes_expr Timestamp_Expr Match if the list contains the provided timestamp CEL expression.
includes_time Timestamp_Relative Match if the list contains the provided relative timestamp.
excludes Timestamp Match if the list does not contain the provided timestamp.
excludes_expr Timestamp_Expr Match if the list does not contain the provided timestamp CEL expression.
excludes_time Timestamp_Relative Match if the list does not contain the provided relative timestamp.
includesAll [Timestamp!] Match if the list contains all the provided timestamps.
excludesAll [Timestamp!] Match if the list contains none of the provided timestamps.

input Timestamp_ListUpdate

Update input of an Timestamp list value.

Field Type Description
append [Timestamp!] Append the provided Timestamp values to the existing list.
prepend [Timestamp!] Prepend the provided Timestamp values to the existing list.

input Timestamp_Relative

A runtime-calculated Timestamp value relative to now or at.

Field Type Description
now True Match for the current time.
at Timestamp A specific timestamp for matching.
add Timestamp_Duration Add the provided duration to the base timestamp.
sub Timestamp_Duration Subtract the provided duration from the base timestamp.
truncateTo Timestamp_Interval Truncate the timestamp to the provided interval.

input Timestamp_Update

Update input of a Timestamp value.

Field Type Description
inc Timestamp_Duration Increment the field by a provided duration.
dec Timestamp_Duration Decrement the field by a provided duration.

input UUID_Filter

Query filter criteria for UUID scalar fields.

Field Type Description
isNull Boolean When true, match if field IS NULL. When false, match if field is NOT NULL.
eq UUID Match if field is exactly equal to provided value.
eq_expr UUID_Expr Match if field is exactly equal to the result of the provided server value expression.
ne UUID Match if field is not equal to provided value.
ne_expr UUID_Expr Match if field is not equal to the result of the provided server value expression.
in [UUID!] Match if field value is among the provided list of values.
nin [UUID!] Match if field value is not among the provided list of values.

input UUID_ListFilter

Query filter criteris for [UUID!] scalar fields.

Field Type Description
includes UUID Match if list field contains the provided value as a member.
excludes UUID Match if list field does not contain the provided value as a member.
includesAll [UUID!] Match if list field contains all of the provided values as members.
excludesAll [UUID!] Match if list field does not contain any of the provided values as members.

input UUID_ListUpdate

Update input of an ID list value.

Field Type Description
append [UUID!] Append the provided UUIDs to the existing list.
prepend [UUID!] Prepend the provided UUIDs to the existing 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 to effectively generate text embeddings.

If you uses Vector in your schema, Firebase Data Connect automatically installs pgvector and google_ml_integration Postgres extensions in your Cloud SQL database.

Given a Post table with a Vector embedding field.

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

NOTE: All natively supported Vector_Embed_Model generates vector of length 768.

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

query SearchPost($query: String!) {
  posts_contentEmbedding_similarity(compare_embed: {model: "textembedding-gecko@003", text: $query}) {
    id
    content
  }
}
Field Type Description
model Vector_Embed_Model! The model to use for vector embedding. Recommend the latest stable model: textembedding-gecko@003.
text String! The text to generate the vector embedding from.

input Vector_Filter

Conditions on a Vector value.

Field Type Description
eq Vector Match if the field is exactly equal to the provided vector.
ne Vector Match if the field is not equal to the provided vector.
in [Vector!] Match if the field value is among the provided list of vectors.
nin [Vector!] Match if the field value is not among the provided list of vectors.
isNull Boolean Match if the field is NULL.

input Vector_ListFilter

Field Type Description
includes Vector Match if the list includes the supplied vector.
excludes Vector Match if the list does not include the supplied vector.
includesAll [Vector!] Match if the list contains all the provided vectors.
excludesAll [Vector!] Match if the list contains none of the provided vectors.

Data 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 ✨ Generated from Field MainTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field MainTable.id of type UUID!)
anyArray [Any!] ✨ Generated from Field MainTable.anyArray of type [Any]
anyArray_update [Any_ListUpdate!] ✨ _update server value variant of anyArray (✨ Generated from Field MainTable.anyArray of type [Any])
anyField Any ✨ Generated from Field MainTable.anyField of type Any
booleanArray [Boolean!] ✨ Generated from Field MainTable.booleanArray of type [Boolean]
booleanArray_update [Boolean_ListUpdate!] ✨ _update server value variant of booleanArray (✨ Generated from Field MainTable.booleanArray of type [Boolean])
booleanField Boolean ✨ Generated from Field MainTable.booleanField of type Boolean
booleanField_expr Boolean_Expr ✨ _expr server value variant of booleanField (✨ Generated from Field MainTable.booleanField of type Boolean)
dateArray [Date!] ✨ Generated from Field MainTable.dateArray of type [Date]
dateArray_update [Date_ListUpdate!] ✨ _update server value variant of dateArray (✨ Generated from Field MainTable.dateArray of type [Date])
dateField Date ✨ Generated from Field MainTable.dateField of type Date
dateField_expr Date_Expr ✨ _expr server value variant of dateField (✨ Generated from Field MainTable.dateField of type Date)
dateField_date Date_Relative ✨ _date server value variant of dateField (✨ Generated from Field MainTable.dateField of type Date)
floatArray [Float!] ✨ Generated from Field MainTable.floatArray of type [Float]
floatArray_update [Float_ListUpdate!] ✨ _update server value variant of floatArray (✨ Generated from Field MainTable.floatArray of type [Float])
floatField Float ✨ Generated from Field MainTable.floatField of type Float
floatField_expr Float_Expr ✨ _expr server value variant of floatField (✨ Generated from Field MainTable.floatField of type Float)
floatField_update [Float_Update!] ✨ _update server value variant of floatField (✨ Generated from Field MainTable.floatField of type Float)
int64Array [Int64!] ✨ Generated from Field MainTable.int64Array of type [Int64]
int64Array_update [Int64_ListUpdate!] ✨ _update server value variant of int64Array (✨ Generated from Field MainTable.int64Array of type [Int64])
int64Field Int64 ✨ Generated from Field MainTable.int64Field of type Int64
int64Field_expr Int64_Expr ✨ _expr server value variant of int64Field (✨ Generated from Field MainTable.int64Field of type Int64)
int64Field_update [Int64_Update!] ✨ _update server value variant of int64Field (✨ Generated from Field MainTable.int64Field of type Int64)
intArray [Int!] ✨ Generated from Field MainTable.intArray of type [Int]
intArray_update [Int_ListUpdate!] ✨ _update server value variant of intArray (✨ Generated from Field MainTable.intArray of type [Int])
intField Int ✨ Generated from Field MainTable.intField of type Int
intField_expr Int_Expr ✨ _expr server value variant of intField (✨ Generated from Field MainTable.intField of type Int)
intField_update [Int_Update!] ✨ _update server value variant of intField (✨ Generated from Field MainTable.intField of type Int)
stringArray [String!] ✨ Generated from Field MainTable.stringArray of type [String]
stringArray_update [String_ListUpdate!] ✨ _update server value variant of stringArray (✨ Generated from Field MainTable.stringArray of type [String])
stringField String ✨ Generated from Field MainTable.stringField of type String
stringField_expr String_Expr ✨ _expr server value variant of stringField (✨ Generated from Field MainTable.stringField of type String)
timestampArray [Timestamp!] ✨ Generated from Field MainTable.timestampArray of type [Timestamp]
timestampArray_update [Timestamp_ListUpdate!] ✨ _update server value variant of timestampArray (✨ Generated from Field MainTable.timestampArray of type [Timestamp])
timestampField Timestamp ✨ Generated from Field MainTable.timestampField of type Timestamp
timestampField_expr Timestamp_Expr ✨ _expr server value variant of timestampField (✨ Generated from Field MainTable.timestampField of type Timestamp)
timestampField_time Timestamp_Relative ✨ _time server value variant of timestampField (✨ Generated from Field MainTable.timestampField of type Timestamp)
uuidArray [UUID!] ✨ Generated from Field MainTable.uuidArray of type [UUID]
uuidArray_update [UUID_ListUpdate!] ✨ _update server value variant of uuidArray (✨ Generated from Field MainTable.uuidArray of type [UUID])
uuidField UUID ✨ Generated from Field MainTable.uuidField of type UUID
uuidField_expr UUID_Expr ✨ _expr server value variant of uuidField (✨ Generated from Field MainTable.uuidField of type UUID)
vectorField Vector ✨ Generated from Field MainTable.vectorField of type Vector
vectorField_embed Vector_Embed ✨ _embed server value variant of vectorField (✨ Generated from Field MainTable.vectorField of type Vector)

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!] Apply multiple filter conditions using AND logic.
_or [MainTable_Filter!] Apply multiple filter conditions using OR logic.
_not MainTable_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field MainTable.id of type UUID!
anyArray Any_ListFilter ✨ Generated from Field MainTable.anyArray of type [Any]
anyField Any_Filter ✨ Generated from Field MainTable.anyField of type Any
booleanArray Boolean_ListFilter ✨ Generated from Field MainTable.booleanArray of type [Boolean]
booleanField Boolean_Filter ✨ Generated from Field MainTable.booleanField of type Boolean
dateArray Date_ListFilter ✨ Generated from Field MainTable.dateArray of type [Date]
dateField Date_Filter ✨ Generated from Field MainTable.dateField of type Date
floatArray Float_ListFilter ✨ Generated from Field MainTable.floatArray of type [Float]
floatField Float_Filter ✨ Generated from Field MainTable.floatField of type Float
int64Array Int64_ListFilter ✨ Generated from Field MainTable.int64Array of type [Int64]
int64Field Int64_Filter ✨ Generated from Field MainTable.int64Field of type Int64
intArray Int_ListFilter ✨ Generated from Field MainTable.intArray of type [Int]
intField Int_Filter ✨ Generated from Field MainTable.intField of type Int
stringArray String_ListFilter ✨ Generated from Field MainTable.stringArray of type [String]
stringField String_Filter ✨ Generated from Field MainTable.stringField of type String
timestampArray Timestamp_ListFilter ✨ Generated from Field MainTable.timestampArray of type [Timestamp]
timestampField Timestamp_Filter ✨ Generated from Field MainTable.timestampField of type Timestamp
uuidArray UUID_ListFilter ✨ Generated from Field MainTable.uuidArray of type [UUID]
uuidField UUID_Filter ✨ Generated from Field MainTable.uuidField of type UUID
vectorField Vector_Filter ✨ Generated from Field MainTable.vectorField of type Vector
manyToManyJoinTables_on_left ManyToManyJoinTable_ListFilter ✨ Generated from Field MainTable.manyToManyJoinTables_on_left of type [ManyToManyJoinTable!]!
manyToManyJoinTables_on_right ManyToManyJoinTable_ListFilter ✨ Generated from Field MainTable.manyToManyJoinTables_on_right of type [ManyToManyJoinTable!]!
manyToOneExamples_on_main ManyToOneExample_ListFilter ✨ Generated from Field MainTable.manyToOneExamples_on_main of type [ManyToOneExample!]!
oneToOneExample_on_main OneToOneExample_Filter ✨ Generated from Field MainTable.oneToOneExample_on_main of type OneToOneExample
mainTables_via_ManyToManyJoinTable_on_left MainTable_ListFilter ✨ Generated from Field MainTable.mainTables_via_ManyToManyJoinTable_on_left of type [MainTable!]!
mainTables_via_ManyToManyJoinTable_on_right MainTable_ListFilter ✨ Generated from Field MainTable.mainTables_via_ManyToManyJoinTable_on_right of type [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 Filters rows based on the specified conditions.
orderBy [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!] Apply multiple Having conditions using AND logic.
_or [MainTable_Having!] Apply multiple Having conditions using OR logic.
_not MainTable_Having Negate the result of the provided Having condition.
_distinct Boolean Whether to apply DISTINCT to the aggregate function.
_count Int_Filter ✨ Generated from Field MainTable._count of type Int!
anyField_count Int_Filter ✨ Generated from Field MainTable.anyField_count of type Int!
booleanField_count Int_Filter ✨ Generated from Field MainTable.booleanField_count of type Int!
dateField_count Int_Filter ✨ Generated from Field MainTable.dateField_count of type Int!
floatField_count Int_Filter ✨ Generated from Field MainTable.floatField_count of type Int!
id_count Int_Filter ✨ Generated from Field MainTable.id_count of type Int!
int64Field_count Int_Filter ✨ Generated from Field MainTable.int64Field_count of type Int!
intField_count Int_Filter ✨ Generated from Field MainTable.intField_count of type Int!
stringField_count Int_Filter ✨ Generated from Field MainTable.stringField_count of type Int!
timestampField_count Int_Filter ✨ Generated from Field MainTable.timestampField_count of type Int!
uuidField_count Int_Filter ✨ Generated from Field MainTable.uuidField_count of type Int!
vectorField_count Int_Filter ✨ Generated from Field MainTable.vectorField_count of type Int!
floatField_sum Float_Filter ✨ Generated from Field MainTable.floatField_sum of type Float
int64Field_sum Int64_Filter ✨ Generated from Field MainTable.int64Field_sum of type Int64
intField_sum Int_Filter ✨ Generated from Field MainTable.intField_sum of type Int
floatField_avg Float_Filter ✨ Generated from Field MainTable.floatField_avg of type Float
int64Field_avg Float_Filter ✨ Generated from Field MainTable.int64Field_avg of type Float
intField_avg Float_Filter ✨ Generated from Field MainTable.intField_avg of type Float
anyField_min Any_Filter ✨ Generated from Field MainTable.anyField_min of type Any
dateField_min Date_Filter ✨ Generated from Field MainTable.dateField_min of type Date
floatField_min Float_Filter ✨ Generated from Field MainTable.floatField_min of type Float
int64Field_min Int64_Filter ✨ Generated from Field MainTable.int64Field_min of type Int64
intField_min Int_Filter ✨ Generated from Field MainTable.intField_min of type Int
timestampField_min Timestamp_Filter ✨ Generated from Field MainTable.timestampField_min of type Timestamp
anyField_max Any_Filter ✨ Generated from Field MainTable.anyField_max of type Any
dateField_max Date_Filter ✨ Generated from Field MainTable.dateField_max of type Date
floatField_max Float_Filter ✨ Generated from Field MainTable.floatField_max of type Float
int64Field_max Int64_Filter ✨ Generated from Field MainTable.int64Field_max of type Int64
intField_max Int_Filter ✨ Generated from Field MainTable.intField_max of type Int
timestampField_max Timestamp_Filter ✨ Generated from Field MainTable.timestampField_max of type 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 ✨ Generated from Field MainTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field MainTable.id of type 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 The desired number of objects that match the condition (defaults to at least one).
exist 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 ✨ Generated from Field MainTable.id of type UUID!
anyField OrderDirection ✨ Generated from Field MainTable.anyField of type Any
booleanField OrderDirection ✨ Generated from Field MainTable.booleanField of type Boolean
dateField OrderDirection ✨ Generated from Field MainTable.dateField of type Date
floatField OrderDirection ✨ Generated from Field MainTable.floatField of type Float
int64Field OrderDirection ✨ Generated from Field MainTable.int64Field of type Int64
intField OrderDirection ✨ Generated from Field MainTable.intField of type Int
stringField OrderDirection ✨ Generated from Field MainTable.stringField of type String
timestampField OrderDirection ✨ Generated from Field MainTable.timestampField of type Timestamp
uuidField OrderDirection ✨ Generated from Field MainTable.uuidField of type UUID
vectorField OrderDirection ✨ Generated from Field MainTable.vectorField of type Vector

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 ✨ Generated from Field ManyToManyJoinTable.leftId of type UUID!
leftId_expr UUID_Expr ✨ _expr server value variant of leftId (✨ Generated from Field ManyToManyJoinTable.leftId of type UUID!)
rightId UUID ✨ Generated from Field ManyToManyJoinTable.rightId of type UUID!
rightId_expr UUID_Expr ✨ _expr server value variant of rightId (✨ Generated from Field ManyToManyJoinTable.rightId of type UUID!)
left MainTable_Key ✨ Generated from Field ManyToManyJoinTable.left of type MainTable!
right MainTable_Key ✨ Generated from Field ManyToManyJoinTable.right of type 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!] Apply multiple filter conditions using AND logic.
_or [ManyToManyJoinTable_Filter!] Apply multiple filter conditions using OR logic.
_not ManyToManyJoinTable_Filter Negate the result of the provided filter condition.
leftId UUID_Filter ✨ Generated from Field ManyToManyJoinTable.leftId of type UUID!
rightId UUID_Filter ✨ Generated from Field ManyToManyJoinTable.rightId of type UUID!
left MainTable_Filter ✨ Generated from Field ManyToManyJoinTable.left of type MainTable!
right MainTable_Filter ✨ Generated from Field ManyToManyJoinTable.right of type 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 Filters rows based on the specified conditions.
orderBy [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!] Apply multiple Having conditions using AND logic.
_or [ManyToManyJoinTable_Having!] Apply multiple Having conditions using OR logic.
_not ManyToManyJoinTable_Having Negate the result of the provided Having condition.
_distinct Boolean Whether to apply DISTINCT to the aggregate function.
_count Int_Filter ✨ Generated from Field ManyToManyJoinTable._count of type Int!
leftId_count Int_Filter ✨ Generated from Field ManyToManyJoinTable.leftId_count of type Int!
rightId_count Int_Filter ✨ Generated from Field ManyToManyJoinTable.rightId_count of type 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 ✨ Generated from Field ManyToManyJoinTable.leftId of type UUID!
leftId_expr UUID_Expr ✨ _expr server value variant of leftId (✨ Generated from Field ManyToManyJoinTable.leftId of type UUID!)
rightId UUID ✨ Generated from Field ManyToManyJoinTable.rightId of type UUID!
rightId_expr UUID_Expr ✨ _expr server value variant of rightId (✨ Generated from Field ManyToManyJoinTable.rightId of type 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 The desired number of objects that match the condition (defaults to at least one).
exist 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 ✨ Generated from Field ManyToManyJoinTable.leftId of type UUID!
rightId OrderDirection ✨ Generated from Field ManyToManyJoinTable.rightId of type UUID!
left MainTable_Order ✨ Generated from Field ManyToManyJoinTable.left of type MainTable!
right MainTable_Order ✨ Generated from Field ManyToManyJoinTable.right of type MainTable!

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 ✨ Generated from Field ManyToOneExample.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field ManyToOneExample.id of type UUID!)
mainId UUID ✨ Generated from Field ManyToOneExample.mainId of type UUID!
mainId_expr UUID_Expr ✨ _expr server value variant of mainId (✨ Generated from Field ManyToOneExample.mainId of type UUID!)
main MainTable_Key ✨ Generated from Field ManyToOneExample.main of type MainTable!
someField Any ✨ Generated from Field ManyToOneExample.someField of type 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!] Apply multiple filter conditions using AND logic.
_or [ManyToOneExample_Filter!] Apply multiple filter conditions using OR logic.
_not ManyToOneExample_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field ManyToOneExample.id of type UUID!
mainId UUID_Filter ✨ Generated from Field ManyToOneExample.mainId of type UUID!
main MainTable_Filter ✨ Generated from Field ManyToOneExample.main of type MainTable!
someField Any_Filter ✨ Generated from Field ManyToOneExample.someField of type 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 Filters rows based on the specified conditions.
orderBy [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!] Apply multiple Having conditions using AND logic.
_or [ManyToOneExample_Having!] Apply multiple Having conditions using OR logic.
_not ManyToOneExample_Having Negate the result of the provided Having condition.
_distinct Boolean Whether to apply DISTINCT to the aggregate function.
_count Int_Filter ✨ Generated from Field ManyToOneExample._count of type Int!
id_count Int_Filter ✨ Generated from Field ManyToOneExample.id_count of type Int!
mainId_count Int_Filter ✨ Generated from Field ManyToOneExample.mainId_count of type Int!
someField_count Int_Filter ✨ Generated from Field ManyToOneExample.someField_count of type Int!
someField_min Any_Filter ✨ Generated from Field ManyToOneExample.someField_min of type Any
someField_max Any_Filter ✨ Generated from Field ManyToOneExample.someField_max of type 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 ✨ Generated from Field ManyToOneExample.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field ManyToOneExample.id of type 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 The desired number of objects that match the condition (defaults to at least one).
exist 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 ✨ Generated from Field ManyToOneExample.id of type UUID!
mainId OrderDirection ✨ Generated from Field ManyToOneExample.mainId of type UUID!
main MainTable_Order ✨ Generated from Field ManyToOneExample.main of type MainTable!
someField OrderDirection ✨ Generated from Field ManyToOneExample.someField of type 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 ✨ Generated from Field OneToOneExample.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field OneToOneExample.id of type UUID!)
mainId UUID ✨ Generated from Field OneToOneExample.mainId of type UUID!
mainId_expr UUID_Expr ✨ _expr server value variant of mainId (✨ Generated from Field OneToOneExample.mainId of type UUID!)
main MainTable_Key ✨ Generated from Field OneToOneExample.main of type MainTable!
someField Any ✨ Generated from Field OneToOneExample.someField of type 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!] Apply multiple filter conditions using AND logic.
_or [OneToOneExample_Filter!] Apply multiple filter conditions using OR logic.
_not OneToOneExample_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field OneToOneExample.id of type UUID!
mainId UUID_Filter ✨ Generated from Field OneToOneExample.mainId of type UUID!
main MainTable_Filter ✨ Generated from Field OneToOneExample.main of type MainTable!
someField Any_Filter ✨ Generated from Field OneToOneExample.someField of type 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 Filters rows based on the specified conditions.
orderBy [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!] Apply multiple Having conditions using AND logic.
_or [OneToOneExample_Having!] Apply multiple Having conditions using OR logic.
_not OneToOneExample_Having Negate the result of the provided Having condition.
_distinct Boolean Whether to apply DISTINCT to the aggregate function.
_count Int_Filter ✨ Generated from Field OneToOneExample._count of type Int!
id_count Int_Filter ✨ Generated from Field OneToOneExample.id_count of type Int!
mainId_count Int_Filter ✨ Generated from Field OneToOneExample.mainId_count of type Int!
someField_count Int_Filter ✨ Generated from Field OneToOneExample.someField_count of type Int!
someField_min Any_Filter ✨ Generated from Field OneToOneExample.someField_min of type Any
someField_max Any_Filter ✨ Generated from Field OneToOneExample.someField_max of type 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 ✨ Generated from Field OneToOneExample.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field OneToOneExample.id of type 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 The desired number of objects that match the condition (defaults to at least one).
exist 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 ✨ Generated from Field OneToOneExample.id of type UUID!
mainId OrderDirection ✨ Generated from Field OneToOneExample.mainId of type UUID!
main MainTable_Order ✨ Generated from Field OneToOneExample.main of type MainTable!
someField OrderDirection ✨ Generated from Field OneToOneExample.someField of type 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 ✨ Generated from Field StringTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field StringTable.id of type UUID!)
nonNullStringArray [String!] ✨ Generated from Field StringTable.nonNullStringArray of type [String!]
nonNullStringArray_update [String_ListUpdate!] ✨ _update server value variant of nonNullStringArray (✨ Generated from Field StringTable.nonNullStringArray of type [String!])
nonNullStringField String ✨ Generated from Field StringTable.nonNullStringField of type String!
nonNullStringField_expr String_Expr ✨ _expr server value variant of nonNullStringField (✨ Generated from Field StringTable.nonNullStringField of type String!)
nonNullStringNonnullArray [String!] ✨ Generated from Field StringTable.nonNullStringNonnullArray of type [String!]!
nonNullStringNonnullArray_update [String_ListUpdate!] ✨ _update server value variant of nonNullStringNonnullArray (✨ Generated from Field StringTable.nonNullStringNonnullArray of type [String!]!)
stringArray [String!] ✨ Generated from Field StringTable.stringArray of type [String]
stringArray_update [String_ListUpdate!] ✨ _update server value variant of stringArray (✨ Generated from Field StringTable.stringArray of type [String])
stringField String ✨ Generated from Field StringTable.stringField of type String
stringField_expr String_Expr ✨ _expr server value variant of stringField (✨ Generated from Field StringTable.stringField of type String)
stringNonnullArray [String!] ✨ Generated from Field StringTable.stringNonnullArray of type [String]!
stringNonnullArray_update [String_ListUpdate!] ✨ _update server value variant of stringNonnullArray (✨ Generated from Field StringTable.stringNonnullArray of type [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!] Apply multiple filter conditions using AND logic.
_or [StringTable_Filter!] Apply multiple filter conditions using OR logic.
_not StringTable_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field StringTable.id of type UUID!
nonNullStringArray String_ListFilter ✨ Generated from Field StringTable.nonNullStringArray of type [String!]
nonNullStringField String_Filter ✨ Generated from Field StringTable.nonNullStringField of type String!
nonNullStringNonnullArray String_ListFilter ✨ Generated from Field StringTable.nonNullStringNonnullArray of type [String!]!
stringArray String_ListFilter ✨ Generated from Field StringTable.stringArray of type [String]
stringField String_Filter ✨ Generated from Field StringTable.stringField of type String
stringNonnullArray String_ListFilter ✨ Generated from Field StringTable.stringNonnullArray of type [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 Filters rows based on the specified conditions.
orderBy [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!] Apply multiple Having conditions using AND logic.
_or [StringTable_Having!] Apply multiple Having conditions using OR logic.
_not StringTable_Having Negate the result of the provided Having condition.
_distinct Boolean Whether to apply DISTINCT to the aggregate function.
_count Int_Filter ✨ Generated from Field StringTable._count of type Int!
id_count Int_Filter ✨ Generated from Field StringTable.id_count of type Int!
nonNullStringField_count Int_Filter ✨ Generated from Field StringTable.nonNullStringField_count of type Int!
stringField_count Int_Filter ✨ Generated from Field StringTable.stringField_count of type 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 ✨ Generated from Field StringTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field StringTable.id of type 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 The desired number of objects that match the condition (defaults to at least one).
exist 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 ✨ Generated from Field StringTable.id of type UUID!
nonNullStringField OrderDirection ✨ Generated from Field StringTable.nonNullStringField of type String!
stringField OrderDirection ✨ Generated from Field StringTable.stringField of type String