Support for IF/THEN/ELSE expressions

Detail name	Value
Changelog Number	9224
Type	New Feature
Status	Resolved
Fix Versions	Exasol 7.0.0
Resolution Date	2020-09-11

Background

Some databases are offering an IF THEN ELSE expression syntax as an alternative to the standard CASE WHEN expression. Exasol already supports IF statements within functions, but not as expressions within regular SQL.

Feature Description

With IF THEN ELSE expressions, users can use an alternative expressions syntax; this increases compatibility with other database systems.

Example:

select IF true THEN 'a' ENDIF;
-- Returns a

select IF false THEN 'a' ELSE 'b' ENDIF;
-- Returns b