SQL validation: how to query with a taxon order

[MortenHofft]

SELECT \"kingdom\", \"kingdomkey\", COUNT(*) AS occurrences FROM occurrence WHERE countryCode = 'PL' GROUP BY \"kingdom\", \"kingdomkey\"

works fine, but below fails with the error From line 1, column 8 to line 1, column 14: Column 'order' not found in any table

{
  "format": "SQL_TSV_ZIP", 
  "sql": "SELECT \"order\", \"orderkey\", COUNT(*) AS occurrences FROM occurrence WHERE countryCode = 'PL' GROUP BY \"order\", \"orderkey\"" 
}

I assume it is related to order being a reserved word. I had thought quoting would do it, but clearly not.

I have double quoted based on https://techdocs.gbif.org/en/data-use/data-cubes

YEAR(…) (or year(…)) and MONTH(…) are SQL functions, so we must quote the name of the columns as "year" and "month" using double quotes.

[MortenHofft]

I got it working. It is order_ which i discovered in https://api.gbif.org/v1/occurrence/download/describe/sql
It might be worth highlighting in the documentation that order is different from everything else. Ideally even in the error response.

[MattBlissett]

It's fixed in the UAT version, and in the UAT documentation.