SQL routines

A SQL routine is a custom, user-defined function authored by a user of SEP 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:

Note

SQL routines are available as a public preview in Starburst Enterprise. Contact Starburst Support with questions or feedback.

More details are available in the following sections:

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