communicte what macros are not supported by tsql-utils

[dataders]

currently the only place where you can see what models are not supported is by looking at integration_tests/dbt_utils/dbt_project.yml (see below) which is not intuitive, but while the YAML is precise the models and tests in the integration tests don't necessarily correspond 1-1 with individual macros.

Maybe something in the README.md? Or perhaps just one issue per macro? However, dbt_utils.group_by() I know we'll never support. worth mentioning?

currently unsupported

after #17 the current macros we still could port are:
test_split_part() (not working on Synapse?)
test_date_spine()
insert_by_period materialization
generate_series()
get_column_values()
get_relations_by_pattern()
get_relations_by_prefix_and_union()
get_url_host()
get_url_parameter()
get_url_path()

tsql-utils/integration_tests/dbt_utils/dbt_project.yml

Lines 22 to 62 in b68b3a9

	models:
	dbt_utils_integration_tests:
	+enabled: true
	cross_db_utils:
	test_dateadd: &disabled
	+enabled: false
	test_datediff: *disabled
	test_hash: *disabled
	test_last_day: *disabled
	test_split_part:
	+enabled: "{{ target.name != 'synapse' }}"
	datetime:
	test_date_spine: *disabled
	materializations: *disabled
	schema_tests:
	data_test_mutually_exclusive_ranges_no_gaps: *disabled
	data_test_mutually_exclusive_ranges_with_gaps: *disabled
	data_test_not_constant: *disabled
	data_test_relationships_where_table_2: *disabled
	data_test_unique_where: *disabled
	data_test_not_null_where: *disabled
	# the following work but only when
	# the dbt-utils submodule macros are overwritten
	data_test_at_least_one: *disabled
	data_people: *disabled
	data_test_expression_is_true: *disabled
	data_test_not_constant: *disabled
	sql:
	test_generate_series: *disabled
	test_get_column_values: *disabled
	test_get_relations_by_pattern: *disabled
	test_get_relations_by_prefix_and_union: *disabled
	test_groupby: *disabled
	get_query_results_as_dict: *disabled
	test_surrogate_key: *disabled
	test_union: *disabled
	web:
	test_url_host: *disabled
	test_url_path: *disabled
	test_urls: *disabled

[alittlesliceoftom]

Above is (I think) the list of macros which are integration tested on dbt_utils, but don't yet work here.

There are also interesting legacy macros that are a bit behind on dbt_utils too, and not fully tested, but represent useful and interesting concepts. For instance - https://github.com/fishtown-analytics/dbt-utils/blob/master/macros/materializations/insert_by_period_materialization.sql the insert by period materialisation here is a useful idea - especially for SQL Server, but doesn't work on a first test in my local and looks like it could generally do with a spruce.

[dataders]

perhaps for all the unsupported macros, we could implement sqlserver__* versions as wrappers for UnsupportedExceptions. @jtcohen6 I remember seeing an example of this somewhere but can't remember now...

[jtcohen6]

Many of the required adapter macros raise an exception in the default implementation, e.g. list_relations_without_caching.