Complex ESQL functions The following complex ESQL functions are described: CASE function CAST function SELECT function ROW constructor function LIST constructor function ROW and LIST combined ROW and LIST comparisons Supported casts Implicit casts Implicit CASTs for comparisons Implicit CASTs for arithmetic operations Implicit CASTs for assignment Data types of values from external databases