Use adapter.quote() for get_table_types_sql

[dbeatty10]

Describe the feature

Use adapter.quote() instead of double-quotes or backticks within macros/sql/get_table_types_sql.sql (as described here
#537 (comment))

Who will this benefit?

This will make things cleaner and more simple when macros are migrated for dbt-labs/dbt-core#4813

[alla-bongard]

I am happy to pick this up!

[dbeatty10]

Awesome @alla-bongard !

The update would go in the following places:

• dbt-utils/macros/sql/get_table_types_sql.sql

  Line 11 in 77dcf2e

  end as "table_type"

• dbt-utils/macros/sql/get_table_types_sql.sql

  Line 21 in 77dcf2e

  end as "table_type"

• dbt-utils/macros/sql/get_table_types_sql.sql

  Line 30 in 77dcf2e

  end as `table_type`

For good measure, these could be optionally updated also:

• dbt-utils/macros/sql/get_tables_by_pattern_sql.sql

  Lines 9 to 10 in 77dcf2e

  	table_schema as "table_schema",
  	table_name as "table_name",

Note: If the bigquery__get_table_types_sql implementation becomes identical to the default__get_table_types_sql one, then it should be removed altogether 🙏

[alla-bongard]

clear, and it was exactly what I did locally! a PR is on the way! :)

[dbeatty10]

🙌