Set up the SQL API via the environment variables here:

https://cube.dev/docs/product/apis-integrations/sql-api#configuration

On v0.35.40 or later, (most recent stable version is recommended), set the following env variables:

CUBESQL_SQL_PUSH_DOWN=true
CUBEJS_ALLOW_UNGROUPED_WITHOUT_PRIMARY_KEY=true