quoting config not working with 1.8

[McKnight-42]

resolves #1074 docs dbt-labs/docs.getdbt.com/#

Problem

During decoupling work we updated some naming conventions in some macros that seem to go around quotiing_policy, reverting to put us back in good standing.

Solution

revert to using schema_relation where able in the adapters.sql if schema_relation is a string, otherwise use schema_relation.include(indentifier=False)

• interactions in test seem to suggest both version are needed see tests/functional/adapter/list_relations_tests/test_pagination.py

update tests in tests/functional/adapter/list_relations_tests/test_pagination.py to use a SnowflakeRelation object instead of a dict

add a new test based of the edgecase from issue.

Todo:

• [x] Make change in macro
• [x] Update current tests
• [x] make new test
• [ ] backport to 1.8.latest after merge

Checklist

• [x] I have read the contributing guide and understand what's expected of me
• [x] I have run this code in development and it appears to resolve the stated issue
• [x] This PR includes tests, or tests are not required/relevant for this PR
• [ ] This PR has no interface changes (e.g. macros, cli, logs, json artifacts, config files, adapter interface, etc) or this PR has already received feedback and approval from Product or DX

[mikealfare]

We do this in two spots, so this line would also need updating.