How to optimize multiple statements at once

[matthewsilver]

Is it possible to optimize several SQL statements at once in Bigquery (I.e., take multiple semicolon-separated statements and consolidate/optimize them)? When I parse such a query, it’s a list of ASTs, so I’m not sure whether this is possible or I can only optimize each one on its own.

[georgesittas]

The optimizer expects a single Expression at a time, so that's indeed not possible. As you said, you can optimize each of them separately.