BigQuery Execute Immediate with a variable

I have a questy that in a nutshell looks like following:

DECLARE variable STRING;

SET variable = (SELECT STRING_AGG(field) FROM table);

EXECUTE IMMEDIATE FORMAT("""SELECT * FROM (%t)""", variable);

But the only error I'm getting is the following:

The statement works fine in GCP