Inputs Types

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

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!

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'
pattern	String_Pattern	Match if field value matches the provided pattern. See String_Pattern for more details.

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_Pattern

The pattern match condition on a string. Specify either like or regex. https://www.postgresql.org/docs/current/functions-matching.html

Field	Type	Description
like	String	Match using the provided LIKE expression.
regex	String	Match using the provided POSIX regular expression.
ignoreCase	Boolean	When true, ignore case when matching.
invert	Boolean	When true, invert the match result. Equivalent to NOT LIKE or !~.

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)
}

Example: Insert embedding

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

Example: Vector similarity Search

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.