Order of IGNORE NULLS in BigQuery generated SQL is incorrect

[cpcloud]

IGNORE NULLS needs to occur before LIMIT, otherwise it's an error.

Fully reproducible code snippet

In [7]: import sqlglot as sg

In [8]: sg.__version__
Out[8]: '21.0.1'

In [9]: sg.parse_one('select array_agg(x ignore nulls limit 1)', read='bigquery').sql('bigquery')
Out[9]: 'SELECT array_agg(x LIMIT 1 IGNORE NULLS)'

Official Documentation

https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate-function-calls

[georgesittas]

This one's tricky, I'm looking into it but haven't figured out the workaround yet.. The parser was recently updated and now the ignore/respect nulls expression is bubbled right above the AggFunc which makes it get generated at the end.