Namespace LfrlAnvil.Sql.Expressions.Functions
Classes
- SqlAbsFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns an absolute value.
- SqlAggregateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an aggregate function invocation.
- SqlAverageAggregateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of an aggregate function that returns an average value.
- SqlByteLengthFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns its parameter's length in bytes.
- SqlCeilingFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns its parameter's ceiling.
- SqlCoalesceFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that null-coalesces its parameters.
- SqlCountAggregateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of an aggregate function that returns the number of records.
- SqlCumulativeDistributionWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that calculates the cumulative distribution.
- SqlCurrentDateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns current date in local timezone.
- SqlCurrentDateTimeFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns current datetime in local timezone.
- SqlCurrentTimeFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns current time of day in local timezone.
- SqlCurrentTimestampFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns current time elapsed since the unix epoch.
- SqlCurrentUtcDateTimeFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns current datetime in UTC timezone.
- SqlDenseRankWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that returns the dense rank of the row.
- SqlExtractDateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that extracts the date part from its parameter.
- SqlExtractDayFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that extracts a day component from its parameter.
- SqlExtractTemporalUnitFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that extracts a desired date or time component from its parameter.
- SqlExtractTimeOfDayFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that extracts the time of day part from its parameter.
- SqlFirstValueWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that calculates the first value.
- SqlFloorFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns its parameter's floor.
- SqlFunctionExpressionNode
Represents an SQL syntax tree expression node that defines a function invocation.
- SqlIndexOfFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns the position of the first occurrence of a value in a string.
- SqlLagWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that calculates the lag value.
- SqlLastIndexOfFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns the position of the last occurrence of a value in a string.
- SqlLastValueWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that calculates the last value.
- SqlLeadWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that calculates the lead value.
- SqlLengthFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns its parameter's length.
- SqlMaxAggregateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of an aggregate function that returns the maximum value.
- SqlMaxFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns the maximum value from the provided range of parameters.
- SqlMinAggregateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of an aggregate function that returns the minimum value.
- SqlMinFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns the minimum value from the provided range of parameters.
- SqlNTileWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that calculates the n-tile.
- SqlNamedAggregateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a custom aggregate function.
- SqlNamedFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a custom function.
- SqlNewGuidFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns a new GUID.
- SqlNthValueWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that calculates the n-th value.
- SqlPowerFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns the value raised to the desired power.
- SqlRankWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that returns the rank of the row.
- SqlReplaceFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns the string value with all occurrences of the specified substring replaced with another specified substring.
- SqlReverseFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns reversed string value.
- SqlRoundFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns the value rounded to the specified decimal precision.
- SqlRowNumberWindowFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a window function that returns the row number.
- SqlSignFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns a numeric sign representation of its parameter.
- SqlSquareRootFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns the value's square root.
- SqlStringConcatAggregateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of an aggregate function that returns a concatenated string.
- SqlSubstringFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns a substring from the provided string.
- SqlSumAggregateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of an aggregate function that returns the sum value.
- SqlTemporalAddFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that adds a value with a given unit to the date and/or time parameter.
- SqlTemporalDiffFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that calculates a difference between two date and/or time parameters and converts the result to the given unit.
- SqlToLowerFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns its parameter with all of its elements converted to their lowercase version.
- SqlToUpperFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns its parameter with all of its elements converted to their uppercase version.
- SqlTrimEndFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns a trimmed version of its parameter. Parameter is trimmed only at the end.
- SqlTrimFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns a trimmed version of its parameter. Parameter is trimmed on both ends.
- SqlTrimStartFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns a trimmed version of its parameter. Parameter is trimmed only at the start.
- SqlTruncateFunctionExpressionNode
Represents an SQL syntax tree expression node that defines an invocation of a function that returns a truncated value.
Enums
- SqlFunctionType
Represents a type of an SqlFunctionExpressionNode or SqlAggregateFunctionExpressionNode instance.
- SqlTemporalUnit
Represents available temporal units for date and/or time related functions.