Database Server: SQL Server
| Name | Supports Query Folding | SQL Equivalent |
|---|---|---|
| Number.E | TRUE | 2.71828182845904 |
| Number.PI | TRUE | 3.14159265358979 |
| Number.Epsilon | TRUE | 4.940656458412465E-324 |
| Number.Abs | TRUE | ABS |
| Number.Acos | TRUE | ACOS |
| Number.Asin | TRUE | ASIN |
| Number.Atan | TRUE | ATAN |
| Number.Atan2 | TRUE | ATN2 |
| Table.ReplaceValue | TRUE | CASE |
| Text.Contains | TRUE | CASE |
| Text.EndsWith | TRUE | CASE |
| Text.StartsWith | TRUE | CASE |
| Value.Equals | TRUE | CASE |
| Number.RoundUp | TRUE | CEILING |
| Text.Combine | TRUE | CONCAT |
| DateTime.From | TRUE | CONVERT |
| Double.From | TRUE | CONVERT |
| Number.From | TRUE | CONVERT |
| Number.ToText | TRUE | CONVERT |
| Text.From | TRUE | CONVERT |
| Number.Cos | TRUE | COS |
| Date.AddDays | TRUE | DATEADD |
| Date.AddMonths | TRUE | DATEADD |
| Date.AddQuarters | TRUE | DATEADD |
| Date.AddWeeks | TRUE | DATEADD |
| Date.AddYears | TRUE | DATEADD |
| Duration.TotalDays | TRUE | DATEDIFF |
| Date.Day | TRUE | DATEPART |
| Date.DayOfWeek | TRUE | DATEPART |
| Date.DayOfYear | TRUE | DATEPART |
| Date.Month | TRUE | DATEPART |
| Date.QuarterOfYear | TRUE | DATEPART |
| Date.WeekOfYear | TRUE | DATEPART |
| Date.Year | TRUE | DATEPART |
| Table.Distinct | TRUE | DISTINCT |
| Date.EndOfMonth | TRUE | EOMONTH |
| Number.Exp | TRUE | EXP |
| Number.RoundDown | TRUE | FLOOR |
| Table.Group | TRUE | GROUP BY |
| List.Contains | TRUE | IN |
| Text.Start | TRUE | LEFT |
| Text.Length | TRUE | LEN |
| Number.Log | TRUE | LOG |
| Number.Log10 | TRUE | LOG10 |
| Text.Lower | TRUE | LOWER |
| Text.TrimStart | TRUE | LTRIM |
| Number.Mod | TRUE | MOD |
| Table.Sort | TRUE | ORDER BY |
| Table.Pivot | TRUE | PIVOT |
| Number.Power | TRUE | POWER |
| Text.Replace | TRUE | REPLACE |
| Text.End | TRUE | RIGHT |
| Number.Round | TRUE | ROUND |
| Text.TrimEnd | TRUE | RTRIM |
| Table.SelectColumns | TRUE | SELECT |
| Number.Sqrt | TRUE | SQRT |
| Number.Tan | TRUE | TAN |
| Table.FirstN | TRUE | TOP |
| Table.Range | TRUE | TOP |
| Text.Trim | TRUE | TRIM |
| Table.Combine | TRUE | UNION ALL |
| Table.Repeat | TRUE | UNION ALL |
| Text.Upper | TRUE | UPPER |
| Table.SelectRows | TRUE | WHERE |
| Date.IsInCurrentDay | TRUE | |
| Date.IsInCurrentMonth | TRUE | |
| Date.IsInCurrentQuarter | TRUE | |
| Date.IsInCurrentWeek | TRUE | |
| Date.IsInCurrentYear | TRUE | |
| Date.IsInNextDay | TRUE | |
| Date.IsInNextMonth | TRUE | |
| Date.IsInNextNDays | TRUE | |
| Date.IsInNextNMonths | TRUE | |
| Date.IsInNextNQuarters | TRUE | |
| Date.IsInNextNWeeks | TRUE | |
| Date.IsInNextNYears | TRUE | |
| Date.IsInNextQuarter | TRUE | |
| Date.IsInNextWeek | TRUE | |
| Date.IsInNextYear | TRUE | |
| Date.IsInPreviousDay | TRUE | |
| Date.IsInPreviousMonth | TRUE | |
| Date.IsInPreviousNDays | TRUE | |
| Date.IsInPreviousNMonths | TRUE | |
| Date.IsInPreviousNQuarters | TRUE | |
| Date.IsInPreviousNWeeks | TRUE | |
| Date.IsInPreviousNYears | TRUE | |
| Date.IsInPreviousQuarter | TRUE | |
| Date.IsInPreviousWeek | TRUE | |
| Date.IsInPreviousYear | TRUE | |
| Date.IsInYearToDate | TRUE | |
| DateTime.FromFileTime | TRUE | |
| DateTime.IsInCurrentHour | TRUE | |
| DateTime.IsInCurrentMinute | TRUE | |
| DateTime.IsInCurrentSecond | TRUE | |
| DateTime.IsInNextHour | TRUE | |
| DateTime.IsInNextMinute | TRUE | |
| DateTime.IsInNextNHours | TRUE | |
| DateTime.IsInNextNMinutes | TRUE | |
| DateTime.IsInNextNSeconds | TRUE | |
| DateTime.IsInNextSecond | TRUE | |
| DateTime.IsInPreviousHour | TRUE | |
| DateTime.IsInPreviousMinute | TRUE | |
| DateTime.IsInPreviousNHours | TRUE | |
| DateTime.IsInPreviousNMinutes | TRUE | |
| DateTime.IsInPreviousNSeconds | TRUE | |
| DateTime.IsInPreviousSecond | TRUE | |
| DateTime.LocalNow | TRUE | |
| DateTimeZone.FixedLocalNow | TRUE | |
| DateTimeZone.FixedUtcNow | TRUE | |
| DateTimeZone.FromFileTime | TRUE | |
| DateTimeZone.LocalNow | TRUE | |
| DateTimeZone.UtcNow | TRUE | |
| Decimal.From | TRUE | |
| List.Combine | TRUE | |
| List.RemoveItems | TRUE | |
| List.Select | TRUE | |
| List.Sort | TRUE | |
| Number.Random | TRUE | |
| Table.AddColumn | TRUE | |
| Table.ColumnNames | TRUE | |
| Table.ColumnsOfType | TRUE | |
| Table.DuplicateColumn | TRUE | |
| Table.ExpandListColumn | TRUE | |
| Table.ExpandRecordColumn | TRUE | |
| Table.ExpandTableColumn | TRUE | |
| Table.FromPartitions | TRUE | |
| Table.Join | TRUE | |
| Table.NestedJoin | TRUE | |
| Table.Partition | TRUE | |
| Table.RemoveColumns | TRUE | |
| Table.RenameColumns | TRUE | |
| Table.ReorderColumns | TRUE | |
| Table.TransformColumnNames | TRUE | |
| Table.Transpose | TRUE | |
| Table.Unpivot | TRUE | |
| Table.UnpivotOtherColumns | TRUE | |
| Text.NewGuid | TRUE | |
| Value.As | TRUE | |
| Character.FromNumber | FALSE | CHAR |
| Text.PositionOf | FALSE | CHARINDEX |
| Date.DayOfWeekName | FALSE | DATENAME |
| Text.Repeat | FALSE | REPLICATE |
| Text.Reverse | FALSE | REVERSE |
| Text.ReplaceRange | FALSE | STUFF |
| Text.At | FALSE | SUBSTRING |
| Text.Range | FALSE | SUBSTRING |
| Character.ToNumber | FALSE | |
| Date.DaysInMonth | FALSE | |
| Date.EndOfDay | FALSE | |
| Date.EndOfQuarter | FALSE | |
| Date.EndOfWeek | FALSE | |
| Date.EndOfYear | FALSE | |
| Date.From | FALSE | |
| Date.IsLeapYear | FALSE | |
| Date.MonthName | FALSE | |
| Date.StartOfDay | FALSE | |
| Date.StartOfMonth | FALSE | |
| Date.StartOfQuarter | FALSE | |
| Date.StartOfWeek | FALSE | |
| Date.StartOfYear | FALSE | |
| Date.ToRecord | FALSE | |
| Date.ToText | FALSE | |
| Date.WeekOfMonth | FALSE | |
| DateTime.AddZone | FALSE | |
| DateTime.Date | FALSE | |
| DateTime.FixedLocalNow | FALSE | |
| DateTime.Time | FALSE | |
| DateTime.ToRecord | FALSE | |
| DateTime.ToText | FALSE | |
| DateTimeZone.ToRecord | FALSE | |
| Duration.Days | FALSE | |
| Duration.From | FALSE | |
| Number.BitwiseAnd | FALSE | |
| Number.BitwiseNot | FALSE | |
| Number.BitwiseOr | FALSE | |
| Number.BitwiseShiftLeft | FALSE | |
| Number.BitwiseShiftRight | FALSE | |
| Number.BitwiseXor | FALSE | |
| Number.Combinations | FALSE | |
| Number.Cosh | FALSE | |
| Number.Factorial | FALSE | |
| Number.FromText | FALSE | |
| Number.IntegerDivide | FALSE | |
| Number.IsEven | FALSE | |
| Number.IsNaN | FALSE | |
| Number.IsOdd | FALSE | |
| Number.Ln | FALSE | |
| Number.NaN | FALSE | |
| Number.NegativeInfinity | FALSE | |
| Number.Permutations | FALSE | |
| Number.PositiveInfinity | FALSE | |
| Number.RandomBetween | FALSE | |
| Number.RoundAwayFromZero | FALSE | |
| Number.RoundTowardZero | FALSE | |
| Number.Sign | FALSE | |
| Number.Sin | FALSE | |
| Number.Sinh | FALSE | |
| Number.Tanh | FALSE | |
| Number.Type | FALSE | |
| Table.AddIndexColumn | FALSE | |
| Table.AddKey | FALSE | |
| Table.AggregateTableColumn | FALSE | |
| Table.AlternateRows | FALSE | |
| Table.Buffer | FALSE | |
| Table.Column | FALSE | |
| Table.ColumnCount | FALSE | |
| Table.CombineColumns | FALSE | |
| Table.Contains | FALSE | |
| Table.ContainsAll | FALSE | |
| Table.ContainsAny | FALSE | |
| Table.DemoteHeaders | FALSE | |
| Table.FillDown | FALSE | |
| Table.FillUp | FALSE | |
| Table.FilterWithDataTable | FALSE | |
| Table.FindText | FALSE | |
| Table.First | FALSE | |
| Table.FirstValue | FALSE | |
| Table.FromColumns | FALSE | |
| Table.FromList | FALSE | |
| Table.FromRecords | FALSE | |
| Table.FromRows | FALSE | |
| Table.FromValue | FALSE | |
| Table.FuzzyGroup | FALSE | |
| Table.FuzzyJoin | FALSE | |
| Table.FuzzyNestedJoin | FALSE | |
| Table.HasColumns | FALSE | |
| Table.InsertRows | FALSE | |
| Table.IsDistinct | FALSE | |
| Table.IsEmpty | FALSE | |
| Table.Keys | FALSE | |
| Table.Last | FALSE | |
| Table.LastN | FALSE | |
| Table.MatchesAllRows | FALSE | |
| Table.MatchesAnyRows | FALSE | |
| Table.Max | FALSE | |
| Table.MaxN | FALSE | |
| Table.Min | FALSE | |
| Table.MinN | FALSE | |
| Table.PartitionValues | FALSE | |
| Table.PositionOf | FALSE | |
| Table.PositionOfAny | FALSE | |
| Table.PrefixColumns | FALSE | |
| Table.Profile | FALSE | |
| Table.PromoteHeaders | FALSE | |
| Table.RemoveFirstN | FALSE | |
| Table.RemoveLastN | FALSE | |
| Table.RemoveMatchingRows | FALSE | |
| Table.RemoveRows | FALSE | |
| Table.RemoveRowsWithErrors | FALSE | |
| Table.ReverseRows | FALSE | |
| Table.RowCount | FALSE | |
| Table.Schema | FALSE | |
| Table.SelectRowsWithErrors | FALSE | |
| Table.SingleRow | FALSE | |
| Table.Skip | FALSE | |
| Table.Split | FALSE | |
| Table.SplitColumn | FALSE | |
| Table.ToList | FALSE | |
| Table.ToRecords | FALSE | |
| Table.ToRows | FALSE | |
| Table.TransformColumns | FALSE | |
| Table.View | FALSE | |
| Table.ViewFunction | FALSE | |
| Text.AfterDelimiter | FALSE | |
| Text.BeforeDelimiter | FALSE | |
| Text.BetweenDelimiters | FALSE | |
| Text.Clean | FALSE | |
| Text.Format | FALSE | |
| Text.FromBinary | FALSE | |
| Text.InferNumberType | FALSE | |
| Text.Insert | FALSE | |
| Text.Middle | FALSE | |
| Text.PadEnd | FALSE | |
| Text.PadStart | FALSE | |
| Text.PositionOfAny | FALSE | |
| Text.Proper | FALSE | |
| Text.Remove | FALSE | |
| Text.RemoveRange | FALSE | |
| Text.Select | FALSE | |
| Text.Split | FALSE | |
| Text.SplitAny | FALSE | |
| Text.ToBinary | FALSE | |
| Text.ToList | FALSE | |
| Text.Type | FALSE | |
| Time.EndOfHour | FALSE | |
| Time.From | FALSE | |
| Time.Hour | FALSE | |
| Time.Minute | FALSE | |
| Time.Second | FALSE | |
| Time.StartOfHour | FALSE | |
| Value.Add | FALSE | |
| Value.Compare | FALSE | |
| Value.Divide | FALSE | |
| Value.FromText | FALSE | |
| Value.Is | FALSE | |
| Value.Metadata | FALSE | |
| Value.Multiply | FALSE | |
| Value.NativeQuery | FALSE | |
| Value.Subtract | FALSE | |
| Date.FromText | ||
| DateTime.FromText | ||
| DateTimeZone.From | ||
| DateTimeZone.FromText | ||
| DateTimeZone.RemoveZone | ||
| DateTimeZone.SwitchZone | ||
| DateTimeZone.ToLocal | ||
| DateTimeZone.ToText | ||
| DateTimeZone.ToUtc | ||
| DateTimeZone.ZoneHours | ||
| DateTimeZone.ZoneMinutes | ||
| Duration.FromText | ||
| Duration.Hours | ||
| Duration.Minutes | ||
| Duration.Seconds | ||
| Duration.ToRecord | ||
| Duration.TotalHours | ||
| Duration.TotalMinutes | ||
| Duration.TotalSeconds | ||
| Duration.ToText | ||
| List.Accumulate | ||
| List.AllTrue | ||
| List.Alternate | ||
| List.AnyTrue | ||
| List.Average | ||
| List.Buffer | ||
| List.ContainsAll | ||
| List.ContainsAny | ||
| List.Count | ||
| List.Covariance | ||
| List.Dates | ||
| List.DateTimes | ||
| List.DateTimeZones | ||
| List.Difference | ||
| List.Distinct | ||
| List.Durations | ||
| List.FindText | ||
| List.First | ||
| List.FirstN | ||
| List.Generate | ||
| List.InsertRange | ||
| List.Intersect | ||
| List.IsDistinct | ||
| List.IsEmpty | ||
| List.Last | ||
| List.LastN | ||
| List.MatchesAll | ||
| List.MatchesAny | ||
| List.Max | ||
| List.MaxN | ||
| List.Median | ||
| List.Min | ||
| List.MinN | ||
| List.Mode | ||
| List.Modes | ||
| List.NonNullCount | ||
| List.Numbers | ||
| List.PositionOf | ||
| List.PositionOfAny | ||
| List.Positions | ||
| List.Product | ||
| List.Random | ||
| List.Range | ||
| List.RemoveFirstN | ||
| List.RemoveLastN | ||
| List.RemoveMatchingItems | ||
| List.RemoveNulls | ||
| List.RemoveRange | ||
| List.Repeat | ||
| List.ReplaceMatchingItems | ||
| List.ReplaceRange | ||
| List.ReplaceValue | ||
| List.Reverse | ||
| List.Single | ||
| List.SingleOrDefault | ||
| List.Skip | ||
| List.Split | ||
| List.StandardDeviation | ||
| List.Sum | ||
| List.Times | ||
| List.Transform | ||
| List.TransformMany | ||
| List.Type | ||
| List.Union | ||
| List.Zip | ||
| Logical.From | ||
| Logical.FromText | ||
| Logical.ToText | ||
| Table.AddJoinColumn | ||
| Table.ReplaceErrorValues | ||
| Table.ReplaceKeys | ||
| Table.ReplaceMatchingRows | ||
| Table.ReplaceRelationshipIdentity | ||
| Table.ReplaceRows | ||
| Table.ToColumns | ||
| Table.TransformColumnTypes | ||
| Table.TransformRows | ||
| Time.FromText | ||
| Time.ToRecord | ||
| Time.ToText | ||
| Value.Firewall | ||
| Value.NullableEquals | ||
| Value.RemoveMetadata | ||
| Value.ReplaceMetadata | ||
| Value.ReplaceType | ||
| Value.ResourceExpression |