pgsql

const (
	// UnsetDataType represents a DataType that has not been visited by any logic. It is the default, zero-value for
	// the DataType type.
	UnsetDataType DataType = ""

	// UnknownDataType represents a DataType that has been visited by type inference logic but remains unknowable.
	UnknownDataType DataType = "unknown"

	Null          DataType = "null"
	Any           DataType = "any"
	NodeComposite DataType = "nodecomposite"
	EdgeComposite DataType = "edgecomposite"
	PathComposite DataType = "pathcomposite"
	Int           DataType = "int"
	Int2          DataType = "int2"
	Int4          DataType = "int4"
	Int8          DataType = "int8"
	Float4        DataType = "float4"
	Float8        DataType = "float8"
	Boolean       DataType = "bool"
	Text          DataType = "text"
	JSONB         DataType = "jsonb"
	Numeric       DataType = "numeric"

	AnyArray           DataType = "anyarray"
	NodeCompositeArray DataType = "nodecomposite[]"
	EdgeCompositeArray DataType = "edgecomposite[]"
	IntArray           DataType = "int[]"
	Int2Array          DataType = "int2[]"
	Int4Array          DataType = "int4[]"
	Int8Array          DataType = "int8[]"
	Float4Array        DataType = "float4[]"
	Float8Array        DataType = "float8[]"
	TextArray          DataType = "text[]"
	JSONBArray         DataType = "jsonb[]"
	NumericArray       DataType = "numeric[]"

	Date                     DataType = "date"
	TimeWithTimeZone         DataType = "time with time zone"
	TimeWithoutTimeZone      DataType = "time without time zone"
	Interval                 DataType = "interval"
	TimestampWithTimeZone    DataType = "timestamp with time zone"
	TimestampWithoutTimeZone DataType = "timestamp without time zone"

	Scope                 DataType = "scope"
	ParameterIdentifier   DataType = "parameter_identifier"
	ExpansionPattern      DataType = "expansion_pattern"
	ExpansionPath         DataType = "expansion_path"
	ExpansionRootNode     DataType = "expansion_root_node"
	ExpansionEdge         DataType = "expansion_edge"
	ExpansionTerminalNode DataType = "expansion_terminal_node"
	PathEdge              DataType = "path_edge"
)

const (
	// FunctionUnidirectionalASPHarness identifies the SQL harness for unidirectional all-shortest-path search.
	FunctionUnidirectionalASPHarness Identifier = "unidirectional_asp_harness"

	// FunctionUnidirectionalSPHarness identifies the SQL harness for unidirectional single-shortest-path search.
	FunctionUnidirectionalSPHarness Identifier = "unidirectional_sp_harness"

	// FunctionBidirectionalASPHarness identifies the SQL harness for bidirectional all-shortest-path search.
	FunctionBidirectionalASPHarness Identifier = "bidirectional_asp_harness"

	// FunctionBidirectionalSPHarness identifies the SQL harness for bidirectional single-shortest-path search.
	FunctionBidirectionalSPHarness Identifier = "bidirectional_sp_harness"

	// FunctionAllShortestPathsDAG identifies the SQL helper that materializes every shortest path from a predecessor DAG.
	FunctionAllShortestPathsDAG Identifier = "all_shortest_paths_dag"

	// FunctionAllShortestPathsNoPathProbe identifies the bounded target-side
	// reachability preflight. It returns an exact empty result only after the
	// reverse component is exhausted; every positive or capped probe delegates
	// to the A1 predecessor-DAG helper.
	FunctionAllShortestPathsNoPathProbe Identifier = "all_shortest_paths_no_path_probe"

	// FunctionShortestPathCompact identifies the SQL helper that materializes one compact shortest-path witness.
	FunctionShortestPathCompact Identifier = "shortest_path_compact"

	// FunctionShortestPathB1StrictAlternating identifies compact bidirectional search with strict node alternation.
	FunctionShortestPathB1StrictAlternating Identifier = "shortest_path_b1_strict_alternating"

	// FunctionShortestPathB2SmallerCurrentLevel identifies compact bidirectional search that expands the smaller current level.
	FunctionShortestPathB2SmallerCurrentLevel Identifier = "shortest_path_b2_smaller_current_level"

	// FunctionAllShortestPathsB1StrictAlternating identifies two-sided predecessor-DAG enumeration with strict node alternation.
	FunctionAllShortestPathsB1StrictAlternating Identifier = "all_shortest_paths_b1_strict_alternating"

	// FunctionAllShortestPathsB2SmallerCurrentLevel identifies two-sided predecessor-DAG enumeration that expands the smaller current level.
	FunctionAllShortestPathsB2SmallerCurrentLevel Identifier = "all_shortest_paths_b2_smaller_current_level"

	// FunctionShortestPathSelfEndpointError identifies the SQL helper that raises an invalid self-endpoint error.
	FunctionShortestPathSelfEndpointError Identifier = "shortest_path_self_endpoint_error"

	// FunctionIntArrayUnique identifies the SQL helper that removes duplicate integer-array values.
	FunctionIntArrayUnique Identifier = "uniq"

	// FunctionIntArraySort identifies the SQL helper that orders integer-array values.
	FunctionIntArraySort Identifier = "sort"

	// FunctionJSONBToTextArray identifies the SQL helper that converts a JSONB array to text[].
	FunctionJSONBToTextArray Identifier = "jsonb_to_text_array"

	// FunctionJSONBArrayElementsText identifies PostgreSQL's JSONB array-element text expansion function.
	FunctionJSONBArrayElementsText Identifier = "jsonb_array_elements_text"

	// FunctionJSONBBuildObject identifies PostgreSQL's JSONB object constructor.
	FunctionJSONBBuildObject Identifier = "jsonb_build_object"

	// FunctionJSONBBuildArray constructs an array without reinterpreting element types.
	FunctionJSONBBuildArray Identifier = "jsonb_build_array"

	// FunctionJSONBArrayElements expands JSON arrays while preserving element types.
	FunctionJSONBArrayElements Identifier = "jsonb_array_elements"

	// FunctionJSONBArrayLength identifies PostgreSQL's JSONB array-length function.
	FunctionJSONBArrayLength Identifier = "jsonb_array_length"

	// FunctionJSONBTypeof identifies PostgreSQL's JSONB type-inspection function.
	FunctionJSONBTypeof Identifier = "jsonb_typeof"

	// FunctionToJSONB identifies PostgreSQL's conversion to JSONB.
	FunctionToJSONB Identifier = "to_jsonb"

	// FunctionTrunc removes the fractional part without rounding.
	FunctionTrunc Identifier = "trunc"

	// FunctionCypherText extracts a runtime string or explicitly converts a scalar.
	FunctionCypherText Identifier = "cypher_text"

	// FunctionCharLength counts Unicode characters in a string.
	FunctionCharLength Identifier = "char_length"

	// FunctionCypherList validates a runtime list without changing element types.
	FunctionCypherList Identifier = "cypher_list"

	// FunctionCypherSize returns the length of a runtime string or list.
	FunctionCypherSize Identifier = "cypher_size"

	// FunctionCypherCompare compares compatible runtime values, returning null for unlike types.
	FunctionCypherCompare Identifier = "cypher_compare"

	// FunctionCypherArithmetic evaluates arithmetic using the runtime JSON value types.
	FunctionCypherArithmetic Identifier = "cypher_arithmetic"

	// FunctionCypherContains identifies the SQL helper implementing Cypher CONTAINS semantics.
	FunctionCypherContains Identifier = "cypher_contains"

	// FunctionCypherStartsWith identifies the SQL helper implementing Cypher STARTS WITH semantics.
	FunctionCypherStartsWith Identifier = "cypher_starts_with"

	// FunctionCypherEndsWith identifies the SQL helper implementing Cypher ENDS WITH semantics.
	FunctionCypherEndsWith Identifier = "cypher_ends_with"

	// FunctionCypherMin identifies the SQL aggregate implementing Cypher minimum semantics.
	FunctionCypherMin Identifier = "cypher_min"

	// FunctionCypherMax identifies the SQL aggregate implementing Cypher maximum semantics.
	FunctionCypherMax Identifier = "cypher_max"

	// FunctionCypherSum sums runtime numbers without converting integers to floats.
	FunctionCypherSum Identifier = "cypher_sum"

	// FunctionArrayLength identifies PostgreSQL's dimension-aware array-length function.
	FunctionArrayLength Identifier = "array_length"

	// FunctionCardinality identifies PostgreSQL's total array-element count function.
	FunctionCardinality Identifier = "cardinality"

	// FunctionArrayAggregate identifies PostgreSQL's array aggregation function.
	FunctionArrayAggregate Identifier = "array_agg"

	// FunctionArrayRemove identifies PostgreSQL's array element-removal function.
	FunctionArrayRemove Identifier = "array_remove"

	// FunctionMin identifies PostgreSQL's minimum aggregate.
	FunctionMin Identifier = "min"

	// FunctionMax identifies PostgreSQL's maximum aggregate.
	FunctionMax Identifier = "max"

	// FunctionSum identifies PostgreSQL's sum aggregate.
	FunctionSum Identifier = "sum"

	// FunctionAvg identifies PostgreSQL's average aggregate.
	FunctionAvg Identifier = "avg"

	// FunctionLocalTimestamp identifies PostgreSQL's local timestamp constructor.
	FunctionLocalTimestamp Identifier = "localtimestamp"

	// FunctionLocalTime identifies PostgreSQL's local time constructor.
	FunctionLocalTime Identifier = "localtime"

	// FunctionCurrentTime identifies PostgreSQL's current zoned time value.
	FunctionCurrentTime Identifier = "current_time"

	// FunctionCurrentDate identifies PostgreSQL's current date value.
	FunctionCurrentDate Identifier = "current_date"

	// FunctionNow identifies PostgreSQL's current transaction timestamp function.
	FunctionNow Identifier = "now"

	// FunctionToLower identifies PostgreSQL's lowercase text function.
	FunctionToLower Identifier = "lower"

	// FunctionToUpper identifies PostgreSQL's uppercase text function.
	FunctionToUpper Identifier = "upper"

	// FunctionCoalesce identifies PostgreSQL's first-non-null expression.
	FunctionCoalesce Identifier = "coalesce"

	// FunctionNullIf identifies PostgreSQL's NULLIF function for nulling matching scalar values.
	FunctionNullIf Identifier = "nullif"

	// FunctionReplace identifies PostgreSQL's substring-replacement function.
	FunctionReplace Identifier = "replace"

	// FunctionUnnest identifies PostgreSQL's array-to-row expansion function.
	FunctionUnnest Identifier = "unnest"

	// FunctionNextValue identifies PostgreSQL's sequence increment function.
	FunctionNextValue Identifier = "nextval"

	// FunctionPGGetSerialSequence identifies PostgreSQL's serial-sequence lookup function.
	FunctionPGGetSerialSequence Identifier = "pg_get_serial_sequence"

	// FunctionJSONBSet identifies PostgreSQL's JSONB path-update function.
	FunctionJSONBSet Identifier = "jsonb_set"

	// FunctionCount identifies PostgreSQL's count aggregate.
	FunctionCount Identifier = "count"

	// FunctionStringToArray identifies PostgreSQL's delimiter-based text-to-array function.
	FunctionStringToArray Identifier = "string_to_array"

	// FunctionEdgesToPath identifies the SQL helper that builds a path from unordered edge composites.
	FunctionEdgesToPath Identifier = "edges_to_path"

	// FunctionOrderedEdgesToPath identifies the SQL helper that builds a path from ordered edge composites.
	FunctionOrderedEdgesToPath Identifier = "ordered_edges_to_path"

	// FunctionOrderedEdgeIDsToPath identifies the SQL helper that hydrates an ordered edge-ID array into a path.
	FunctionOrderedEdgeIDsToPath Identifier = "ordered_edge_ids_to_path"

	// FunctionNodesToPath identifies the SQL helper that builds a path from ordered node composites.
	FunctionNodesToPath Identifier = "nodes_to_path"

	// FunctionKindName identifies the SQL helper that resolves a kind ID to its name.
	FunctionKindName Identifier = "kind_name"

	// FunctionStartNode identifies the SQL helper that hydrates a relationship's start node.
	FunctionStartNode Identifier = "start_node"

	// FunctionEndNode identifies the SQL helper that hydrates a relationship's end node.
	FunctionEndNode Identifier = "end_node"

	// FunctionExtract identifies PostgreSQL's temporal component-extraction function.
	FunctionExtract Identifier = "extract"

	// FunctionGenerateSubscripts identifies PostgreSQL's array-index generation function.
	FunctionGenerateSubscripts Identifier = "generate_subscripts"
	FunctionCypherLikeEscape   Identifier = "cypher_like_escape"
)

const (
	WildcardIdentifier Identifier = "*"
	EpochIdentifier    Identifier = "epoch"
)

const (
	StringLiteralNull       = "null"
	StringLiteralEmptyArray = "[]"

	TableNode Identifier = "node"
	TableEdge Identifier = "edge"
	TableKind Identifier = "kind"

	ColumnID         Identifier = "id"
	ColumnName       Identifier = "name"
	ColumnPath       Identifier = "path"
	ColumnProperties Identifier = "properties"
	ColumnKindIDs    Identifier = "kind_ids"
	ColumnKindID     Identifier = "kind_id"
	ColumnGraphID    Identifier = "graph_id"
	ColumnStartID    Identifier = "start_id"
	ColumnEndID      Identifier = "end_id"
	ColumnNodes      Identifier = "nodes"
	ColumnEdges      Identifier = "edges"
)

const (
	// JoinTypeInner retains rows that satisfy the join constraint on both sides.
	JoinTypeInner JoinType = iota

	// JoinTypeLeftOuter retains every left row even when no right row matches.
	JoinTypeLeftOuter

	// JoinTypeRightOuter retains every right row even when no left row matches.
	JoinTypeRightOuter

	// JoinTypeFullOuter retains unmatched rows from both sides.
	JoinTypeFullOuter
)

const (
	UnsetOperator                 Operator = ""
	OperatorUnion                 Operator = "union"
	OperatorConcatenate           Operator = "||"
	OperatorArrayOverlap          Operator = "&&"
	OperatorEquals                Operator = "="
	OperatorNotEquals             Operator = "!="
	OperatorGreaterThan           Operator = ">"
	OperatorGreaterThanOrEqualTo  Operator = ">="
	OperatorLessThan              Operator = "<"
	OperatorLessThanOrEqualTo     Operator = "<="
	OperatorLike                  Operator = "like"
	OperatorILike                 Operator = "ilike"
	OperatorPGArrayOverlap        Operator = "operator (pg_catalog.&&)"
	OperatorPGArrayLHSContainsRHS Operator = "operator (pg_catalog.@>)"
	OperatorAnd                   Operator = "and"
	OperatorOr                    Operator = "or"
	OperatorNot                   Operator = "not"
	OperatorJSONBFieldExists      Operator = "?"
	OperatorJSONField             Operator = "->"
	OperatorJSONTextField         Operator = "->>"
	OperatorAdd                   Operator = "+"
	OperatorSubtract              Operator = "-"
	OperatorMultiply              Operator = "*"
	OperatorDivide                Operator = "/"
	OperatorIn                    Operator = "in"
	OperatorIs                    Operator = "is"
	OperatorIsNot                 Operator = "is not"
	OperatorSimilarTo             Operator = "similar to"
	OperatorRegexMatch            Operator = "~"
	OperatorAssignment            Operator = "="
	OperatorAdditionAssignment    Operator = "+="
	OperatorIsDistinctFrom        Operator = "is distinct from"
	OperatorIsNotDistinctFrom     Operator = "is not distinct from"

	OperatorCypherRegexMatch Operator = "=~"
	OperatorCypherStartsWith Operator = "starts with"
	OperatorCypherContains   Operator = "contains"
	OperatorCypherEndsWith   Operator = "ends with"
	OperatorCypherNotEquals  Operator = "<>"

	OperatorPropertyLookup Operator = "property_lookup"
	OperatorKindAssignment Operator = "kind_assignment"
)

const (
	// WindowFrameBoundaryTypeCurrentRow anchors a window boundary at the current row or peer group.
	WindowFrameBoundaryTypeCurrentRow WindowFrameBoundaryType = iota

	// WindowFrameBoundaryTypePreceding places a window boundary before the current row.
	WindowFrameBoundaryTypePreceding

	// WindowFrameBoundaryTypeFollowing places a window boundary after the current row.
	WindowFrameBoundaryTypeFollowing
)

const (
	// WindowFrameUnitRows measures frame boundaries in physical rows.
	WindowFrameUnitRows WindowFrameUnit = iota

	// WindowFrameUnitRange measures frame boundaries by ordering-key value ranges.
	WindowFrameUnitRange

	// WindowFrameUnitGroups measures frame boundaries in peer groups.
	WindowFrameUnitGroups
)