The following SQL keywords are reserved words for RAQL queries. Keywords are shown in lower case. Matching is not case sensitive.
Column and function names in queries that match reserved keywords must be delimited with double quote marks ( " ) to prevent errors in query execution.
Note: Single quote marks ( ' ) are used to delimit literal values that are string, and thus are not valid to delimit names.
Reserved keywords
abs |
false |
natural |
then |
all |
first |
not |
to |
and |
first_value |
now |
trailing |
any |
float |
nth_value |
trim |
array |
floor |
ntile |
true |
as |
following |
null |
trunc |
asc |
for |
nulls |
truncate |
avg |
from |
on |
unbounded |
between |
full |
or |
union |
big_decimal |
group |
order |
unknown |
blob |
grouping |
outer |
upper |
boolean |
having |
over |
using |
by |
hour |
partition |
variance |
byte |
hours |
pattern |
var_pop |
case |
in |
power |
var_samp |
cast |
inner |
preceding |
week |
ceil |
integer |
range |
weeks |
ceiling |
intersect |
rank |
when |
character |
is |
recursive |
where |
character_length |
join |
ref |
window |
char_length |
lag |
regr_intercept |
with |
clob |
last |
regr_slope |
within |
corr |
last_value |
relative |
year |
count |
lead |
right |
years |
covar |
leading |
round |
|
covar_pop |
left |
row |
|
covar_samp |
like |
rows |
|
cross |
limit |
row_number |
|
cube |
ln |
seconds |
|
cume_dist |
long |
seconds |
|
current |
lower |
select |
|
date |
matching |
sets |
|
day |
max |
shift |
|
days |
measures |
short |
|
default |
millisecond |
slide |
|
define |
milliseconds |
sql_date |
|
dense_rank |
min |
sql_time |
|
desc |
minus |
sql_timestamp |
|
distinct |
minute |
sqrts |
|
do |
minutes |
stddev |
|
double |
mod |
stddev_pop |
|
duration |
month |
stddev_samp |
|
else |
months |
string |
|
end |
struct |
||
except |
substring |
||
exp |
sum |
||
explain |