SQL routines

A SQL routine is a custom, user-defined function authored by a user of Trino in a client and written in the SQL routine language. Routines are scalar functions that return a single output value. More details are available in the following sections:

• Introduction
• Examples
• BEGIN
• CASE
• DECLARE
• FUNCTION
• IF
• ITERATE
• LEAVE
• LOOP
• REPEAT
• RETURN
• SET
• WHILE