Kysoql
ReferenceAPI reference

Core API reference

Generated API reference for query builders, schema types, compilation, plugins, and SOQL helpers in @kysoql/core.

Functions

FunctionDescription
apexAddBuilds a typed Apex addition expression from compatible literal or bind operands.
apexBindCreates a typed Apex bind expression from an identifier or dotted member path.
apexQueryFieldReferences a selected field from an Apex query result for use in another bind expression.
apexSubstringBuilds a typed Apex substring expression using validated zero-based indexes.
applyQueryResultAliasesApplies Kysoql-only field aliases to records returned by Salesforce.
soqlCurrencyCreates a validated SOQL currency literal from a three-letter ISO code and finite value.
soqlLikeLiteralTreat every character in a LIKE value literally, including % and _.
soqlMultiSelectAndCreates a multi-select picklist operand that requires every listed value to match.
soqlRelativeDateCreates a validated fixed or parameterized Salesforce relative-date literal.
soqlDateCreates a validated Salesforce SOQL date literal.
soqlDateTimeCreates a validated Salesforce SOQL datetime literal.
soqlTimeCreates a validated Salesforce SOQL time literal.

Classes

ClassDescription
KysoqlConfigured query creator for building, compiling, and optionally executing typed SOQL.
NoResultErrorError thrown by executeTakeFirstOrThrow() when a query returns no rows.
DefaultQueryCompilerDefault compiler that validates a query AST and renders Salesforce SOQL.
QueryCreatorEntry point for creating typed queries from a Salesforce schema.

Interfaces

InterfaceDescription
ApexBindExpressionTyped Apex expression that can be embedded as a bind in generated dynamic SOQL.
ApexDatabaseQueryOptionsCompile-time marker for Salesforce Database.QueryOptions.
AggregateFormatFunctionBuilderBuilder for FORMAT() applied to an aggregate expression.
AggregateFunctionBuilderBuilder for a typed Salesforce aggregate function expression.
AggregateFunctionExpressionTyped aggregate-function expression that can be selected or compared.
AggregateFunctionModuleAggregate and date-function helpers exposed to expression callbacks.
AliasedAggregateFunctionBuilderAliased aggregate expression produced for SELECT output.
AliasedDateFunctionBuilderAliased date-function expression produced for SELECT output.
AliasedSelectFunctionBuilderAliased scalar SELECT-function expression.
ConvertCurrencyFunctionBuilderBuilder for Salesforce convertCurrency() expressions.
ConvertTimezoneFunctionBuilderBuilder for an unaliased Salesforce convertTimezone() expression.
CountAllFunctionBuilderBuilder for Salesforce COUNT() without a field argument.
DateFunctionBuilderBuilder for Salesforce date functions such as CALENDAR_YEAR() and DAY_ONLY().
DateFunctionExpressionTyped Salesforce date-function expression that can be selected or grouped.
FormatFunctionBuilderBuilder for Salesforce FORMAT() expressions.
GroupingFunctionBuilderBuilder for Salesforce GROUPING() in aggregate queries.
SelectExpressionBuilderExpression helper passed to typed SELECT and grouping callbacks.
SelectFunctionModuleScalar, aggregate, date, and geolocation helpers exposed to SELECT callbacks.
ToLabelFunctionBuilderBuilder for Salesforce toLabel() expressions.
ExpressionBuilderExpression helper passed to typed WHERE callbacks.
ExpressionWrapperTyped wrapper around a filter operation node.
ToLabelFilterFunctionExpressionTyped toLabel() expression used in WHERE comparisons.
BetaExpressionModuleBeta expression helpers for Salesforce formula-field filter functions.
FormulaFilterFunctionExpressionTyped formula-function expression used in WHERE comparisons.
AliasedDistanceFunctionBuilderAliased DISTANCE() expression produced for SELECT output.
DistanceFunctionBuilderBuilder for Salesforce DISTANCE() expressions.
DistanceFunctionExpressionTyped Salesforce DISTANCE() expression.
GeolocationExpressionBuilderExpression helper for geolocation-aware SELECT and ORDER BY callbacks.
GeolocationFilterExpressionBuilderExpression helper for geolocation-aware WHERE callbacks.
GeolocationFilterFunctionModuleGeolocation expression helpers exposed to WHERE callbacks.
GeolocationFunctionBuilderBuilder for Salesforce GEOLOCATION() expressions.
GeolocationFunctionModuleGeolocation expression helpers exposed to SELECT and ORDER BY callbacks.
HavingExpressionBuilderExpression helper passed to typed HAVING callbacks.
HavingExpressionWrapperTyped wrapper around an aggregate HAVING expression node.
AggregateFunctionNodeImmutable query AST node for a Salesforce aggregate function.
AliasNodeImmutable query AST node for a SELECT alias.
AllRowsNodeImmutable query AST node for the ALL ROWS modifier.
AndNodeImmutable query AST node for logical AND.
ApexAccessModeNodeImmutable query AST node for an Apex query access mode.
ApexBindNodeImmutable query AST node for an Apex bind reference.
ApexAdditionNodeImmutable query AST node for an Apex addition expression.
ApexQueryResultNodeImmutable query AST node for a field read from an Apex query result.
ApexSubstringNodeImmutable query AST node for an Apex substring expression.
ApexLiteralNodeImmutable query AST node for an Apex literal value.
BinaryOperationNodeImmutable query AST node for a binary filter comparison.
ConvertCurrencyFunctionNodeImmutable query AST node for a convertCurrency() expression.
ConvertTimezoneFunctionNodeImmutable query AST node for a convertTimezone() expression.
DateFunctionNodeImmutable query AST node for a Salesforce date or fiscal date function.
DistanceFunctionNodeImmutable query AST node for a DISTANCE() expression.
FieldsFunctionNodeImmutable query AST node for a FIELDS() selection.
ForUpdateNodeImmutable query AST node for the FOR UPDATE clause.
ForViewReferenceNodeImmutable query AST node for a FOR VIEW or FOR REFERENCE clause.
FormatFunctionNodeImmutable query AST node for a FORMAT() expression.
FormulaFunctionNodeImmutable query AST node for a Salesforce formula filter function.
GeolocationFunctionNodeImmutable query AST node for a GEOLOCATION() expression.
GroupByNodeImmutable query AST node for a GROUP BY clause.
HavingNodeImmutable query AST node for a HAVING clause.
KnowledgeUpdateNodeImmutable query AST node for a Salesforce Knowledge UPDATE clause.
LimitNodeImmutable query AST node for a LIMIT clause.
NotNodeImmutable query AST node for logical NOT.
OffsetNodeImmutable query AST node for an OFFSET clause.
OperationNodeUnion of immutable query AST node shapes understood by the Kysoql compiler.
OperatorNodeImmutable query AST node for a comparison operator.
OrNodeImmutable query AST node for logical OR.
OrderByItemNodeImmutable query AST node for one ORDER BY item.
OrderByNodeImmutable query AST node for an ORDER BY clause.
RawNodeImmutable query AST node for a trusted raw SOQL fragment.
RecordVisibilityContextNodeImmutable query AST node for a record-visibility context clause.
ReferenceNodeImmutable query AST node for a field or relationship reference.
RelationshipSubqueryNodeImmutable query AST node for a child relationship subquery.
SelectQueryNodeImmutable query AST node for a complete SELECT query.
SelectionNodeImmutable query AST node for one SELECT projection.
SemiJoinSubqueryNodeImmutable query AST node for a semi-join or anti-join subquery.
SetOptionsNodeImmutable query AST node for a SET OPTIONS clause.
SObjectNodeImmutable query AST node for a Salesforce object reference.
ToLabelFunctionNodeImmutable query AST node for a toLabel() expression.
TypeOfNodeImmutable query AST node for a TYPEOF selection.
TypeOfWhenNodeImmutable query AST node for one TYPEOF WHEN branch.
UserProfileFeedWithNodeImmutable query AST node for a UserProfileFeed WITH clause.
UsingScopeNodeImmutable query AST node for a USING SCOPE clause.
ValueListNodeImmutable query AST node for a list of bound SOQL values.
ValueNodeImmutable query AST node for a bound SOQL value.
WhereNodeImmutable query AST node for a WHERE clause.
DataCategorySelectionNodeImmutable query AST node for one WITH DATA CATEGORY selection.
WithDataCategoryNodeImmutable query AST node for a WITH DATA CATEGORY clause.
Data360DloSetOptionsSET OPTIONS supported by Salesforce Data 360 data lake objects.
Data360DmoSetOptionsSET OPTIONS supported by Salesforce Data 360 data model objects.
KysoqlPluginHook contract for transforming Kysoql query trees and execution results.
PluginTransformQueryArgsArguments passed to a plugin before a query is compiled.
PluginTransformResultArgsArguments passed to a plugin after a query has executed.
AggregateSelectQueryBuilderType-safe builder for grouped and aggregate Salesforce SELECT queries.
ApexAggregateSelectQueryBuilderApex rendering wrapper for an aggregate SELECT query.
ApexCountQueryBuilderApex rendering wrapper for a COUNT() query.
ApexSelectQueryBuilderApex rendering wrapper for a typed SELECT query.
CountQueryBuilderType-safe builder for Salesforce COUNT() queries.
ExecuteTakeFirstOrThrowOptionsOptions for customising the error thrown when a query returns no rows.
RelationshipSubqueryBuilderType-safe builder for a Salesforce child relationship subquery.
RelationshipSubqueryPilotModulePilot-only features available while building a relationship subquery.
SelectQueryBuilderType-safe fluent builder for Salesforce SELECT queries.
SelectQueryBuilderPropsInternal construction state exposed for advanced query-builder integrations.
SelectedSemiJoinSubqueryBuilderCompleted semi-join subquery with its selected reference field.
SemiJoinQueryCreatorQuery-creator contract exposed inside semi-join callbacks.
SemiJoinSubqueryBuilderBuilder for the filtering portion of a semi-join subquery.
SemiJoinSubqueryExpressionTyped semi-join or anti-join subquery expression for IN and NOT IN filters.
TypeOfBuilderBuilder for Salesforce TYPEOF polymorphic relationship selections.
TypeOfElseBuilderCompleted TYPEOF builder after adding an ELSE branch.
TypeOfWhenBuilderTYPEOF builder after adding a WHEN branch.
CompiledQueryCompiled SOQL text paired with the immutable query AST that produced it.
QueryCompileContextAdditional schema metadata and mode supplied while compiling a query.
QueryCompilerCompiler contract for turning a SelectQueryNode into executable SOQL.
QueryCreatorConfigCompiler, executor, and plugin configuration for QueryCreator.
AbortableQueryOptionsOptions shared by executable query builders and query executors.
QueryAbortSignalMinimal structural contract used for query cancellation.
QueryExecutorExecution adapter contract used by query builders and QueryCreator.
QueryIdIdentifies a single query transformation/execution lifecycle.
SalesforceChildRelationshipMetadata for a Salesforce child relationship reference.
SalesforceFieldMetadataMetadata that describes Salesforce field capabilities in a Kysoql schema.
SalesforceGeolocationLatitude and longitude value used by Salesforce geolocation fields.
SalesforceObjectType-level description of one Salesforce object and its query capabilities.
SalesforceParentRelationshipMetadata for a Salesforce parent relationship reference.
SalesforceQueryResultPaginated Salesforce query response shape.
SalesforceRecordAttributesStandard Salesforce record attributes returned by REST query responses.
SalesforceSchemaMetadataOptional runtime metadata emitted alongside generated Salesforce schemas.
SoqlRawBuilderA trusted SOQL fragment that is emitted verbatim by the compiler.
SoqlCurrencyLiteralValidated ISO currency literal used in Salesforce SOQL comparisons.
SoqlLikeLiteralLIKE operand wrapper that treats percent and underscore characters literally.
SoqlMultiSelectAndRepresents Salesforce's semicolon-delimited multi-select picklist operand, where every listed value must be selected on the matching record.
SoqlRelativeDateLiteralBranded Salesforce relative-date literal accepted by date and datetime filters.
SoqlDateLiteralValidated Salesforce SOQL date literal.
SoqlDateTimeLiteralValidated Salesforce SOQL datetime literal with an explicit UTC offset.
SoqlTimeLiteralValidated Salesforce SOQL time literal in UTC.
KysoqlTypeErrorCompile-time error marker used by fluent helpers that intentionally return an unusable type when a type assertion cannot be proven.

Type Aliases

Type AliasDescription
ApexAdditionOperandLiteral or typed Apex bind expression accepted by apexAdd().
ApexAdditionValuePrimitive value types supported by Apex addition expressions.
AggregatableFieldReferenceRestricts a field reference to Salesforce fields that support aggregation.
ConvertTimezoneIdentityType-level identity used to track a convertTimezone() expression.
CurrencyFieldReferenceRestricts a field reference to currency values supported by convertCurrency().
DateFunctionIdentityType-level identity used to track a date-function expression through a query.
DateGroupableFieldReferenceRestricts a field reference to date or datetime fields that can be grouped.
FormattableFieldReferenceRestricts a field reference to values supported by FORMAT().
NumericAggregatableFieldReferenceRestricts a field reference to numeric Salesforce fields that support aggregation.
TranslatableFieldReferenceRestricts a field reference to values supported by toLabel().
FilterableToLabelFieldReferenceRestricts a field reference to filterable values supported by toLabel().
ToLabelFilterComparisonOperatorComparison operators supported when filtering a toLabel() expression.
WhereExpressionFactoryCallback that builds a typed WHERE expression from an ExpressionBuilder.
FilterableFormulaFieldReferenceRestricts a field reference to fields accepted by formula filter functions.
FormulaFilterComparisonOperatorComparison operators supported by formula filter functions.
FilterableLocationFieldReferenceRestricts a field reference to filterable Salesforce geolocation fields.
LocationFieldReferenceRestricts a field reference to Salesforce geolocation fields.
GroupedHavingFieldNameField names that can be referenced directly in an aggregate HAVING clause.
HavingExpressionFactoryCallback that builds a typed HAVING expression.
AggregateFunctionSalesforce aggregate function names represented in the query AST.
AggregateFunctionNode-
AliasNode-
AllRowsNode-
AndNode-
ApexAccessModeApex query access modes supported by Salesforce Database query methods.
ApexAccessModeNode-
ApexBindNode-
ApexAdditionNode-
ApexBindExpressionNodeImmutable query AST node for a supported Apex bind expression.
ApexExpressionOperandNodeImmutable query AST node for an Apex expression operand.
ApexQueryResultNode-
ApexSubstringNode-
ApexLiteralNode-
ApexLiteralValuePrimitive literal values supported inside Apex bind expressions.
BinaryOperationNode-
ConvertCurrencyFunctionNode-
ConvertTimezoneFunctionNode-
DateFunctionSalesforce date and fiscal date function names supported by Kysoql.
DateFunctionArgumentNodeImmutable query AST node for a Salesforce date-function argument.
DateFunctionNode-
DistanceDestinationNodeImmutable query AST node for the destination of a DISTANCE() expression.
DistanceFunctionNode-
DistanceUnitUnits accepted by Salesforce DISTANCE() expressions.
FieldsFunctionNode-
FieldsSelectorSelectors accepted by Salesforce FIELDS().
ForUpdateNode-
ForViewReferenceModeSalesforce FOR VIEW and FOR REFERENCE query modes.
ForViewReferenceNode-
FormatFunctionNode-
FormulaArithmeticOperatorArithmetic operators supported by Salesforce formula filter functions.
FormulaFunctionNode-
GeolocationFunctionNode-
AdvancedGroupByModeAdvanced Salesforce GROUP BY modes supported by Kysoql.
GroupByNode-
HavingNode-
KnowledgeUpdateModeSalesforce Knowledge UPDATE TRACKING and UPDATE VIEWSTAT modes.
KnowledgeUpdateNode-
LimitNode-
NotNode-
OffsetNode-
ComparisonOperatorUnion of comparison operators supported by Kysoql filters.
EqualityComparisonOperatorSOQL equality comparison operators.
LikeComparisonOperatorSOQL LIKE comparison operator.
MultiSelectComparisonOperatorSOQL INCLUDES and EXCLUDES operators for multi-select picklists.
OperatorNode-
OrderedComparisonOperatorSOQL ordered comparison operators.
SetComparisonOperatorSOQL IN and NOT IN comparison operators.
OrNode-
OrderByDirectionSort directions accepted by SOQL ORDER BY.
OrderByItemNode-
OrderByNullsNULLS FIRST and NULLS LAST modifiers accepted by SOQL ORDER BY.
OrderByNode-
RawNode-
RecordVisibilityContextNode-
ReferenceNode-
RelationshipSubqueryNode-
SelectQueryNode-
SelectionNode-
SemiJoinSubqueryNode-
SetOptionsNode-
SObjectNode-
ToLabelFunctionNode-
TypeOfNode-
UserProfileFeedWithNode-
UsingScopeNode-
ValueListNode-
ValueNode-
WhereNode-
DataCategorySelectionNode-
DataCategorySelectorSelectors accepted by Salesforce WITH DATA CATEGORY.
WithDataCategoryNode-
ApexOperandValueExpressionValue accepted where a dynamic Apex expression or literal may be used.
DataCategoryInputInput accepted when adding a Salesforce WITH DATA CATEGORY filter.
DistanceComparisonOperatorComparison operators accepted for Salesforce DISTANCE() predicates.
RecordVisibilityContextOptionsOptions for Salesforce record-visibility context clauses.
Data360AggregateSetOptionsForAggregate-query SET OPTIONS shape selected from a Salesforce object capability.
Data360SetOptionsForSET OPTIONS shape selected from a Salesforce object capability.
ApexQueryContextControls how a query is rendered for static or dynamic Apex.
NoResultErrorConstructorError constructor accepted by executeTakeFirstOrThrow() when no row is returned.
SelectQueryModeTracks mutually exclusive SELECT-function and TYPEOF query modes at compile time.
SemiJoinSubqueryFactoryCallback that builds a typed semi-join or anti-join subquery.
TypeOfElseFieldListField list accepted by a TYPEOF ELSE branch.
TypeOfFieldListField list accepted by a TYPEOF WHEN branch.
SalesforceFieldDescribes one Salesforce field.
SalesforceFieldCustomExtracts whether a Salesforce field is custom.
SalesforceFieldFilterValueExtracts the value type accepted when filtering a Salesforce field.
SalesforceFieldValueExtracts the selected runtime value type for a Salesforce field.
SalesforceObjectDataCategoryExtracts valid data-category values for a Salesforce object and group.
SalesforceObjectDataCategoryGroupExtracts the valid data-category group names for a Salesforce object type.
SalesforceObjectFieldsCompleteLegacy structural schemas without this metadata retain their old behaviour.
SalesforceObjectMruEnabledExtracts whether a Salesforce object supports MRU-dependent query features.
SalesforceObjectSetOptionsCapabilityExtracts the SET OPTIONS capability for a Salesforce object.
SalesforceObjectSupportedScopeExtracts the USING SCOPE values supported by a Salesforce object.
SalesforceRowMaps a Salesforce object schema to its full row value shape.
SalesforceSchemaBase shape for a Kysoql Salesforce schema.
SalesforceSetOptionsCapabilitySET OPTIONS capability recorded for a generated Salesforce object schema.
SoqlRelativeDateFamilyParameterized Salesforce relative-date literal families such as LAST_N_DAYS.
SoqlRelativeDateValueValidated fixed or parameterized Salesforce relative-date literal value.
SoqlTemporalLiteralUnion of validated SOQL date, datetime, and time literals.
NarrowPartialNarrows selected output properties without changing the generated SOQL.
NotNullMarker used by $narrowType() to remove null from a selected field.

Variables

VariableDescription
soqlSOQL literal helpers, including the explicit unsafe raw-fragment escape hatch.

On this page