Starting a transaction in a task is not possible

[buseynehannes]

Describe the bug
I'm trying to start a transaction in a task to execute multiple statements

To Reproduce
Steps to reproduce the behavior:

1. Create an example migration with the following task

CREATE OR REPLACE TASK EXAMPLE_TASK
    WAREHOUSE = EXPLORATION
    SCHEDULE = '5 minutes'
AS
    BEGIN
    START TRANSACTION;
    SELECT * FROM SOME_TABLE;
    SELECT * FROM SOME_TABLE;
    COMMIT;
END;

2. execute the migration -> fails on EOF error
3. render and execute in snowflake worksheet -> works perfectly

Expected behavior
Since the rendered template works in a snowflake worksheet, I'd expect this to work in a migration too

Schemachange (please complete the following information):

• Version (e.g. 3.5.3): 3.6.1

Additional context
I'm using Repeatable read isolation in my task, so I need the transaction, tried using BEGIN TRANSACTION too, same issue.