The `compare_and_classify_query_results` macro doesn't work on Trino

[adam-tokarski]

Describe the bug

When trying to use audit_helper.compare_and_classify_query_results on Trino database, it fails with

Unexpected parameters (varchar, bigint) for function count. Expected: count(), count(t) T"

Steps to reproduce

1. Prepare sql definition using audit_helper.compare_and_classify_query_results
2. Try to call dbt run on that

Expected results

That it works?

Actual results

Fails during creating a view; view is not created.

Screenshots and log output

Database Error in model my_model (models/audit_my_model.sql)
TrinoUserError(type=USER_ERROR, name=FUNCTION_NOT_FOUND, message="line 232:13: Unexpected parameters (varchar, bigint) for function count. Expected: count(), count(t) T", query_id=20251117_140555_75379_3f6y3)

System information

packages:
  - package: dbt-labs/codegen
    version: 0.13.1
  - package: brooklyn-data/dbt_artifacts
    version: 2.9.3
  - package: dbt-labs/dbt_utils
    version: 1.3.1
  - package: metaplane/dbt_expectations
    version: 0.10.9
  - package: godatadriven/dbt_date
    version: 0.15.0
  - package: dbt-labs/audit_helper
    version: 0.12.2

Which database are you using dbt with?

• postgres
• redshift
• bigquery
• snowflake
• other (specify: Trino)

The output of dbt --version:
1.9.8

The operating system you're using:
Linux

The output of python --version:
3.11.13

Additional context

https://trino.io/docs/current/functions/aggregate.html#count

Are you interested in contributing the fix?

Sure!

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.