including database name in relation causes issue w/ SSDT about dbt-synapse HOT 1 OPEN

+1 on disabling three-part names by default.

If a statement includes references to objects that don't exist, Synapse will respond with "USE is not supported on this platform" instead of a more developer-friendly error message telling you what object "does not exist or you don't have permission".

This hints that the query engine might be translating three-part database names into multiple USE statements, the failure of any of which triggers the error handling for USE not being a supported language element in Synapse DSP.

MS Docs ref: https://learn.microsoft.com/sql/t-sql/language-elements/use-transact-sql

The following override macros work around the issue (lifted from the SO question)

{% macro ref(model_name) %}
    {% do return(builtins.ref(model_name).include(database=false)) %}
{% endmacro %}

{% macro source(source_name, table_name) %}
    {% do return(builtins.source(source_name, table_name).include(database=false)) %}
{% endmacro %}

from dbt-synapse.