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
set [Any!] Set the list with the provided values.
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 Any_Update

Update input of an Any value.

Field Type Description
set Any Set the field to a provided value.

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.
ne Boolean Match if field is not equal to provided value.
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
set [Boolean!] Set the list with the provided values.
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 Boolean_Update

Update input of a Boolean value.

Field Type Description
set Boolean Set the field to a provided value.

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
set [Date!] Replace the current list with the provided list of Date values.
append [Date!] Append the provided Date values to the existing list.
prepend [Date!] Prepend the provided Date values to the existing list.
delete Int Remove the date value at the specified index.
i Int The index of the list to perform updates.
update Date Update the date value at the specified index.

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
set Date Set the field to the provided date.
set_expr Date_Expr Set the field to the provided date CEL expression.
set_date Date_Relative Set the field to the provided relative date.

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.
ne Float Match if field is not equal to provided value.
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.
ge Float Match if field value is greater than or equal to the provided value.
lt Float Match if field value is less than the provided value.
le Float Match if field value is less than or equal to the provided value.

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
set [Float!] Set the list with the provided values.
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
set Float Set the field to a provided value.
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.
ne Int64 Match if field is not equal to provided value.
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.
ge Int64 Match if field value is greater than or equal to the provided value.
lt Int64 Match if field value is less than the provided value.
le Int64 Match if field value is less than or equal to the provided value.

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
set [Int64!] Replace the list with the provided values.
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
set Int64 Set the field to a provided value.
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.
ne Int Match if field is not equal to provided value.
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.
ge Int Match if field value is greater than or equal to the provided value.
lt Int Match if field value is less than the provided value.
le Int Match if field value is less than or equal to the provided value.

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
set [Int!] Set the list with the provided values.
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
set Int Set the field to a provided value.
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
set [String!] Set the list with the provided values.
append [String!] Append the provided values to the existing list.
prepend [String!] Prepend the provided values to the existing list.

input String_Update

Update input of a String value.

Field Type Description
set String Set the field to a provided value.
set_expr String_Expr Set the field to a provided server value expression.

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
set [Timestamp!] Replace the current list with the provided list of Timestamp values.
append [Timestamp!] Append the provided Timestamp values to the existing list.
prepend [Timestamp!] Prepend the provided Timestamp values to the existing list.
delete Int Remove the timestamp value at the specified index.
i Int The index of the list to perform updates.
update Timestamp Update the timestamp value at the specified index.

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
set Timestamp Set the field to the provided timestamp.
set_expr Timestamp_Expr Set the field to the provided timestamp CEL expression.
set_time Timestamp_Relative Set the field to the provided relative timestamp.

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.
ne UUID Match if field is not equal to provided value.
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
set [UUID!] Set the list with the provided list of UUIDs.
append [UUID!] Append the provided UUIDs to the existing list.
prepend [UUID!] Prepend the provided UUIDs to the existing list.

input UUID_Update

Update input of a UUID value.

Field Type Description
set UUID Set the field to a provided UUID.
set_expr UUID_Expr Set the field to a provided UUID expression.

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.

input Vector_ListUpdate

Update input of a Vector list value.

Field Type Description
set [Vector] Replace the current list with the provided list of Vector values.
append [Vector] Append the provided Vector values to the existing list.
prepend [Vector] Prepend the provided Vector values to the existing list.
delete Int Delete the vector at the specified index.
i Int The index of the vector to be updated.
update Vector Update the vector at the specified index.

input Vector_Update

Update input of a Vector value.

Field Type Description
set Vector Set the field to the provided vector value.
set_embed Vector_Embed Set the field to the vector embedding result from a text input.

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]
anyField Any ✨ Generated from Field MainTable.anyField of type Any
booleanArray [Boolean!] ✨ Generated from Field MainTable.booleanArray of type [Boolean]
booleanField Boolean ✨ Generated from Field MainTable.booleanField of type Boolean
dateArray [Date!] ✨ 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]
floatField Float ✨ Generated from Field MainTable.floatField of type Float
int64Array [Int64!] ✨ Generated from Field MainTable.int64Array of type [Int64]
int64Field Int64 ✨ Generated from Field MainTable.int64Field of type Int64
intArray [Int!] ✨ Generated from Field MainTable.intArray of type [Int]
intField Int ✨ Generated from Field MainTable.intField of type Int
stringArray [String!] ✨ 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]
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]
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_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_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_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_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!]
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!]!
stringArray [String!] ✨ 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]!

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_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