Whitelist of SQL functions, operations, and tokens

To help ensure the security of the environment, any SQL statements that you create, and which target an Infor cloud source, are parsed against a whitelist of safe SQL constructs. SQL query syntax must meet SQL ANSI 92 standards. The whitelist is applied only where Infor cloud sources might be affected.

These SQL functions, operations, and tokens are allowed:

Functions and operations Tokens
abs All
acos Ampersand
ascii And
asin Any
atan As
atan2 Asc
avg AsciiStringLiteral
cast AsciiStringOrQuotedIdentifier
ceiling Between
char By
charindex Case
concat Circumflex
cos Coalesce
cot Colon
count Comma
cume_dist Cross
current_timestamp Delete
datefomparts Desc
datepart Distinct
datetime2fromparts Divide
datetimefromparts Dot
datetimeoffsetfromparts Double
degrees DoubleColon
dense_rank Else
exp End
first_value EqualsSign
floor Except
format Exists
getdate Fetch
grouping From
grouping_id Full
lag GreaterThan
last_value Group
lead Having
left HexLiteral
len Identifier
log In
log10 Inner
lower Insert
ltrim Integer
max Intersect
min Into
ntile Is
percent_rank Join
percentile_cont Left
percentile_disc LeftCurly
pi LeftParenthesis
power LessThan
radians Like
rand Merge
rank Minus
replace MultilineComment
replicate Not
reverse Null
right Nullif
round Numeric
row_number On
rtrim Or
sign Order
sin Outer
sqrt Over
stdev Percent
stdevp PercentSign
substring Plus
sum QuoteIdentifier
sysdatetime Real
sysdatetimeoffset Right
tan RightCurly
timefromparts RightOuterJoin
trim RightParenthesis
upper Select
var Semicolon
varp Set
SingleLineComment
Some
Star
Then
Tilde
UnicodeStringLiteral
Union
Update
Values
Variable
VerticalLine
When
Where
WhiteSpace