Functions are available in transformations, in the projection widget, they allow the user to gain insight into the specified data, or to transform it. Case expression is used while creating a SQL to define different conditions such as When, Then, Else, or End. In time and date functions, you can use conditions such as Current time, Current date, Current timestamp, etc.