Inputs Object Types

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

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 BasicTable_Data

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

Field Type Description
id UUID ✨ Generated from Field BasicTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field BasicTable.id of type UUID!)
booleanArrayField [Boolean!] ✨ Generated from Field BasicTable.booleanArrayField of type [Boolean]
booleanField Boolean ✨ Generated from Field BasicTable.booleanField of type Boolean
dateArrayField [Date!] ✨ Generated from Field BasicTable.dateArrayField of type [Date]
dateField Date ✨ Generated from Field BasicTable.dateField of type Date
dateField_expr Date_Expr ✨ _expr server value variant of dateField (✨ Generated from Field BasicTable.dateField of type Date)
dateField_date Date_Relative ✨ _date server value variant of dateField (✨ Generated from Field BasicTable.dateField of type Date)
floatArrayField [Float!] ✨ Generated from Field BasicTable.floatArrayField of type [Float]
floatField Float ✨ Generated from Field BasicTable.floatField of type Float
int64ArrayField [Int64!] ✨ Generated from Field BasicTable.int64ArrayField of type [Int64]
int64Field Int64 ✨ Generated from Field BasicTable.int64Field of type Int64
intArrayField [Int!] ✨ Generated from Field BasicTable.intArrayField of type [Int]
intField Int ✨ Generated from Field BasicTable.intField of type Int
stringArrayField [String!] ✨ Generated from Field BasicTable.stringArrayField of type [String]
stringField String ✨ Generated from Field BasicTable.stringField of type String
stringField_expr String_Expr ✨ _expr server value variant of stringField (✨ Generated from Field BasicTable.stringField of type String)
timestampArrayField [Timestamp!] ✨ Generated from Field BasicTable.timestampArrayField of type [Timestamp]
timestampField Timestamp ✨ Generated from Field BasicTable.timestampField of type Timestamp
timestampField_expr Timestamp_Expr ✨ _expr server value variant of timestampField (✨ Generated from Field BasicTable.timestampField of type Timestamp)
timestampField_time Timestamp_Relative ✨ _time server value variant of timestampField (✨ Generated from Field BasicTable.timestampField of type Timestamp)
uuidArrayField [UUID!] ✨ Generated from Field BasicTable.uuidArrayField of type [UUID]
uuidField UUID ✨ Generated from Field BasicTable.uuidField of type UUID
uuidField_expr UUID_Expr ✨ _expr server value variant of uuidField (✨ Generated from Field BasicTable.uuidField of type UUID)
vectorField Vector ✨ Generated from Field BasicTable.vectorField of type Vector
vectorField_embed Vector_Embed ✨ _embed server value variant of vectorField (✨ Generated from Field BasicTable.vectorField of type Vector)

input BasicTable_Filter

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

Field Type Description
_and [BasicTable_Filter!] Apply multiple filter conditions using AND logic.
_or [BasicTable_Filter!] Apply multiple filter conditions using OR logic.
_not BasicTable_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field BasicTable.id of type UUID!
booleanArrayField Boolean_ListFilter ✨ Generated from Field BasicTable.booleanArrayField of type [Boolean]
booleanField Boolean_Filter ✨ Generated from Field BasicTable.booleanField of type Boolean
dateArrayField Date_ListFilter ✨ Generated from Field BasicTable.dateArrayField of type [Date]
dateField Date_Filter ✨ Generated from Field BasicTable.dateField of type Date
floatArrayField Float_ListFilter ✨ Generated from Field BasicTable.floatArrayField of type [Float]
floatField Float_Filter ✨ Generated from Field BasicTable.floatField of type Float
int64ArrayField Int64_ListFilter ✨ Generated from Field BasicTable.int64ArrayField of type [Int64]
int64Field Int64_Filter ✨ Generated from Field BasicTable.int64Field of type Int64
intArrayField Int_ListFilter ✨ Generated from Field BasicTable.intArrayField of type [Int]
intField Int_Filter ✨ Generated from Field BasicTable.intField of type Int
stringArrayField String_ListFilter ✨ Generated from Field BasicTable.stringArrayField of type [String]
stringField String_Filter ✨ Generated from Field BasicTable.stringField of type String
timestampArrayField Timestamp_ListFilter ✨ Generated from Field BasicTable.timestampArrayField of type [Timestamp]
timestampField Timestamp_Filter ✨ Generated from Field BasicTable.timestampField of type Timestamp
uuidArrayField UUID_ListFilter ✨ Generated from Field BasicTable.uuidArrayField of type [UUID]
uuidField UUID_Filter ✨ Generated from Field BasicTable.uuidField of type UUID
vectorField Vector_Filter ✨ Generated from Field BasicTable.vectorField of type Vector

input BasicTable_FirstRow

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

Field Type Description
where BasicTable_Filter Filters rows based on the specified conditions.
orderBy [BasicTable_Order!] Order the result by the specified fields.

input BasicTable_Key

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

Field Type Description
id UUID ✨ Generated from Field BasicTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field BasicTable.id of type UUID!)

input BasicTable_ListFilter

✨ Generated list filter input type for table 'BasicTable'. 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 BasicTable_Filter Condition of the related objects to filter for.

input BasicTable_Order

✨ Generated order input type for table 'BasicTable'. 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 BasicTable.id of type UUID!
booleanField OrderDirection ✨ Generated from Field BasicTable.booleanField of type Boolean
dateField OrderDirection ✨ Generated from Field BasicTable.dateField of type Date
floatField OrderDirection ✨ Generated from Field BasicTable.floatField of type Float
int64Field OrderDirection ✨ Generated from Field BasicTable.int64Field of type Int64
intField OrderDirection ✨ Generated from Field BasicTable.intField of type Int
stringField OrderDirection ✨ Generated from Field BasicTable.stringField of type String
timestampField OrderDirection ✨ Generated from Field BasicTable.timestampField of type Timestamp
uuidField OrderDirection ✨ Generated from Field BasicTable.uuidField of type UUID
vectorField OrderDirection ✨ Generated from Field BasicTable.vectorField of type Vector

input JoinTable_Data

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

Field Type Description
leftId UUID ✨ Generated from Field JoinTable.leftId of type UUID!
leftId_expr UUID_Expr ✨ _expr server value variant of leftId (✨ Generated from Field JoinTable.leftId of type UUID!)
rightId UUID ✨ Generated from Field JoinTable.rightId of type UUID!
rightId_expr UUID_Expr ✨ _expr server value variant of rightId (✨ Generated from Field JoinTable.rightId of type UUID!)
left LeftTable_Key ✨ Generated from Field JoinTable.left of type LeftTable!
right RightTable_Key ✨ Generated from Field JoinTable.right of type RightTable!

input JoinTable_Filter

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

Field Type Description
_and [JoinTable_Filter!] Apply multiple filter conditions using AND logic.
_or [JoinTable_Filter!] Apply multiple filter conditions using OR logic.
_not JoinTable_Filter Negate the result of the provided filter condition.
leftId UUID_Filter ✨ Generated from Field JoinTable.leftId of type UUID!
rightId UUID_Filter ✨ Generated from Field JoinTable.rightId of type UUID!
left LeftTable_Filter ✨ Generated from Field JoinTable.left of type LeftTable!
right RightTable_Filter ✨ Generated from Field JoinTable.right of type RightTable!

input JoinTable_FirstRow

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

Field Type Description
where JoinTable_Filter Filters rows based on the specified conditions.
orderBy [JoinTable_Order!] Order the result by the specified fields.

input JoinTable_Key

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

Field Type Description
leftId UUID ✨ Generated from Field JoinTable.leftId of type UUID!
leftId_expr UUID_Expr ✨ _expr server value variant of leftId (✨ Generated from Field JoinTable.leftId of type UUID!)
rightId UUID ✨ Generated from Field JoinTable.rightId of type UUID!
rightId_expr UUID_Expr ✨ _expr server value variant of rightId (✨ Generated from Field JoinTable.rightId of type UUID!)

input JoinTable_ListFilter

✨ Generated list filter input type for table 'JoinTable'. 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 JoinTable_Filter Condition of the related objects to filter for.

input JoinTable_Order

✨ Generated order input type for table 'JoinTable'. 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 JoinTable.leftId of type UUID!
rightId OrderDirection ✨ Generated from Field JoinTable.rightId of type UUID!
left LeftTable_Order ✨ Generated from Field JoinTable.left of type LeftTable!
right RightTable_Order ✨ Generated from Field JoinTable.right of type RightTable!

input LeftTable_Data

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

Field Type Description
id UUID ✨ Generated from Field LeftTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field LeftTable.id of type UUID!)

input LeftTable_Filter

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

Field Type Description
_and [LeftTable_Filter!] Apply multiple filter conditions using AND logic.
_or [LeftTable_Filter!] Apply multiple filter conditions using OR logic.
_not LeftTable_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field LeftTable.id of type UUID!
joinTables_on_left JoinTable_ListFilter ✨ Generated from Field LeftTable.joinTables_on_left of type [JoinTable!]!
rightTables_via_JoinTable RightTable_ListFilter ✨ Generated from Field LeftTable.rightTables_via_JoinTable of type [RightTable!]!

input LeftTable_FirstRow

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

Field Type Description
where LeftTable_Filter Filters rows based on the specified conditions.
orderBy [LeftTable_Order!] Order the result by the specified fields.

input LeftTable_Key

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

Field Type Description
id UUID ✨ Generated from Field LeftTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field LeftTable.id of type UUID!)

input LeftTable_ListFilter

✨ Generated list filter input type for table 'LeftTable'. 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 LeftTable_Filter Condition of the related objects to filter for.

input LeftTable_Order

✨ Generated order input type for table 'LeftTable'. 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 LeftTable.id of type UUID!

input ManyTable_Data

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

Field Type Description
id UUID ✨ Generated from Field ManyTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field ManyTable.id of type UUID!)
oneTableId UUID ✨ Generated from Field ManyTable.oneTableId of type UUID!
oneTableId_expr UUID_Expr ✨ _expr server value variant of oneTableId (✨ Generated from Field ManyTable.oneTableId of type UUID!)
oneTable OneTable_Key ✨ Generated from Field ManyTable.oneTable of type OneTable!

input ManyTable_Filter

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

Field Type Description
_and [ManyTable_Filter!] Apply multiple filter conditions using AND logic.
_or [ManyTable_Filter!] Apply multiple filter conditions using OR logic.
_not ManyTable_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field ManyTable.id of type UUID!
oneTableId UUID_Filter ✨ Generated from Field ManyTable.oneTableId of type UUID!
oneTable OneTable_Filter ✨ Generated from Field ManyTable.oneTable of type OneTable!

input ManyTable_FirstRow

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

Field Type Description
where ManyTable_Filter Filters rows based on the specified conditions.
orderBy [ManyTable_Order!] Order the result by the specified fields.

input ManyTable_Key

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

Field Type Description
id UUID ✨ Generated from Field ManyTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field ManyTable.id of type UUID!)

input ManyTable_ListFilter

✨ Generated list filter input type for table 'ManyTable'. 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 ManyTable_Filter Condition of the related objects to filter for.

input ManyTable_Order

✨ Generated order input type for table 'ManyTable'. 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 ManyTable.id of type UUID!
oneTableId OrderDirection ✨ Generated from Field ManyTable.oneTableId of type UUID!
oneTable OneTable_Order ✨ Generated from Field ManyTable.oneTable of type OneTable!

input MaybeTable_Data

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

Field Type Description
id UUID ✨ Generated from Field MaybeTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field MaybeTable.id of type UUID!)
oneTableId UUID ✨ Generated from Field MaybeTable.oneTableId of type UUID!
oneTableId_expr UUID_Expr ✨ _expr server value variant of oneTableId (✨ Generated from Field MaybeTable.oneTableId of type UUID!)
oneTable OneTable_Key ✨ Generated from Field MaybeTable.oneTable of type OneTable!

input MaybeTable_Filter

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

Field Type Description
_and [MaybeTable_Filter!] Apply multiple filter conditions using AND logic.
_or [MaybeTable_Filter!] Apply multiple filter conditions using OR logic.
_not MaybeTable_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field MaybeTable.id of type UUID!
oneTableId UUID_Filter ✨ Generated from Field MaybeTable.oneTableId of type UUID!
oneTable OneTable_Filter ✨ Generated from Field MaybeTable.oneTable of type OneTable!

input MaybeTable_FirstRow

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

Field Type Description
where MaybeTable_Filter Filters rows based on the specified conditions.
orderBy [MaybeTable_Order!] Order the result by the specified fields.

input MaybeTable_Key

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

Field Type Description
id UUID ✨ Generated from Field MaybeTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field MaybeTable.id of type UUID!)

input MaybeTable_ListFilter

✨ Generated list filter input type for table 'MaybeTable'. 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 MaybeTable_Filter Condition of the related objects to filter for.

input MaybeTable_Order

✨ Generated order input type for table 'MaybeTable'. 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 MaybeTable.id of type UUID!
oneTableId OrderDirection ✨ Generated from Field MaybeTable.oneTableId of type UUID!
oneTable OneTable_Order ✨ Generated from Field MaybeTable.oneTable of type OneTable!

input OneTable_Data

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

Field Type Description
id UUID ✨ Generated from Field OneTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field OneTable.id of type UUID!)

input OneTable_Filter

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

Field Type Description
_and [OneTable_Filter!] Apply multiple filter conditions using AND logic.
_or [OneTable_Filter!] Apply multiple filter conditions using OR logic.
_not OneTable_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field OneTable.id of type UUID!
manyTables_on_oneTable ManyTable_ListFilter ✨ Generated from Field OneTable.manyTables_on_oneTable of type [ManyTable!]!
maybeTables_on_oneTable MaybeTable_ListFilter ✨ Generated from Field OneTable.maybeTables_on_oneTable of type [MaybeTable!]!

input OneTable_FirstRow

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

Field Type Description
where OneTable_Filter Filters rows based on the specified conditions.
orderBy [OneTable_Order!] Order the result by the specified fields.

input OneTable_Key

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

Field Type Description
id UUID ✨ Generated from Field OneTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field OneTable.id of type UUID!)

input OneTable_ListFilter

✨ Generated list filter input type for table 'OneTable'. 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 OneTable_Filter Condition of the related objects to filter for.

input OneTable_Order

✨ Generated order input type for table 'OneTable'. 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 OneTable.id of type UUID!

input RightTable_Data

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

Field Type Description
id UUID ✨ Generated from Field RightTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field RightTable.id of type UUID!)

input RightTable_Filter

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

Field Type Description
_and [RightTable_Filter!] Apply multiple filter conditions using AND logic.
_or [RightTable_Filter!] Apply multiple filter conditions using OR logic.
_not RightTable_Filter Negate the result of the provided filter condition.
id UUID_Filter ✨ Generated from Field RightTable.id of type UUID!
joinTables_on_right JoinTable_ListFilter ✨ Generated from Field RightTable.joinTables_on_right of type [JoinTable!]!
leftTables_via_JoinTable LeftTable_ListFilter ✨ Generated from Field RightTable.leftTables_via_JoinTable of type [LeftTable!]!

input RightTable_FirstRow

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

Field Type Description
where RightTable_Filter Filters rows based on the specified conditions.
orderBy [RightTable_Order!] Order the result by the specified fields.

input RightTable_Key

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

Field Type Description
id UUID ✨ Generated from Field RightTable.id of type UUID!
id_expr UUID_Expr ✨ _expr server value variant of id (✨ Generated from Field RightTable.id of type UUID!)

input RightTable_ListFilter

✨ Generated list filter input type for table 'RightTable'. 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 RightTable_Filter Condition of the related objects to filter for.

input RightTable_Order

✨ Generated order input type for table 'RightTable'. 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 RightTable.id of type UUID!