Continuing the discussion from Supporting DBMS platforms other than SQL Server, PostgreSQL, Oracle and RedShift :
I’m taking another look at BigQuery support. An issue that I’m running into with the queries in Achilles_v5.sql is that they sometimes do things of this form:
- select complex_expression( col ) from t group by complex_expression( col )
BigQuery can’t handle this properly and complains that col needs to be in the group by clause. Adding BigQuery-specific translation rules to SqlRender to give the following could work:
- select complex_expression( col ) from t group by col
However, so far it seems like doing that in SqlRender isn’t going to be straightforward. As an alternative, I’m wondering if it might be permissible to change the queries to this form in Achilles_v5.sql:
- select complex_expression( col ) from t group by 1
Are there any currently supported DBMS systems that this would break?