Migrate to new framework for adapter testing during v1.1 upgrade

[jtcohen6]

Hey dbt-trino maintainers!

We've been developing a new framework for all integration/functional testing in dbt-core. One of our goals in the initiative has been to replace the suite of basic test cases for adapter plugins.

For now, the framework is comprised of:

• Pytest utilities included in dbt-core==1.1.0b1
• A set of "basic" test cases, at exact parity with the test cases built into the old .dbtspec / pytest-dbt-adapter

I have some draft docs (dbt-labs/docs.getdbt.com#1263) for using the new framework: https://deploy-preview-1263--docs-getdbt-com.netlify.app/docs/contributing/testing-a-new-adapter

It should be much easier to:

• Override/reimplement test cases (as you've done here)
• "Opt into" test cases for more-advanced functionality, which we'll be gradually adding into the same package of adapter-facing test cases
• Add your own functional test cases for Trino-specific behavior, using the same built-in utilities, and reusing project fixtures if appropriate

If it proves helpful, you can also check out the way we've implemented the framework in some of our own adapter plugins:

• Initial code to use dbt.tests.adapter in Redshift dbt-labs/dbt-redshift#81
• Initial use of adapter test framework dbt-labs/dbt-snowflake#106
• Implement initial adapter tests on bigquery dbt-labs/dbt-bigquery#142
• Initial attempt to get spark working with new testing framework dbt-labs/dbt-spark#299

Thanks for all the great work :)

[hovaesco]

Resolved by #65