These SQL syntax changes are inherited from SQL Anywhere:
CREATE PROCEDURE statement SQL SECURITY INVOKER | DEFINER clauses, which indicate whether to run the procedure as the user calling the routine (invoker) or the user who owns the routine (definer). See Reference: Statements and Options.
SELECT statement INTO TEMPORARY TABLE clause. See Reference: Statements and Options.