BEGIN ... END

BEGIN initiates a block of statements where declared variables exist only until the corresponding END.

Grammar Syntax

BEGIN
  sql_statement_list
END;

Click here to go to the BigQuery specification for this syntax.

The grammar is fully supported by Snowflake.

Sample Source Patterns

BigQuery

CREATE OR REPLACE PROCEDURE test.proc1(INOUT x INT64, delta INT64)
BEGIN
  SET x = x + delta;
END;

Snowflake

CREATE OR REPLACE PROCEDURE test.proc1 (x INT, delta INT)
RETURNS VARIANT
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
BEGIN
    x := x + delta;
    RETURN x;
END;
$$;