Add Microsoft Fabric Data Warehouse support (+ SQL Server and Synapse)

[sdebruyn]

Summary

Adds support for Microsoft Fabric Data Warehouse (adapter type: fabric). Tested with dbt-fabric.

Fabric uses T-SQL with BIT for booleans, which requires several SQL pattern changes. Most changes are cross-platform improvements that benefit all adapters:

• Boolean handling: Replaced bare booleans in WHERE/CASE with explicit comparisons (column = cast(1 as {{ dbt.type_boolean() }})), boolean expressions in SELECT with CASE WHEN, and true/false literals with cast(1/0 as {{ dbt.type_boolean() }}))
• GROUP BY ordinals: Replaced GROUP BY 1, 2 with column names (Fabric DW does not support ordinal positions in CTEs)
• String concatenation: Replaced || with {{ dbt.concat() }} (T-SQL uses +, not ||)
• where false: Replaced with where 1=0 (T-SQL has no false keyword)

Fabric-specific additions:

• fabric__recursive_dag — loop-based approach since Fabric DW does not support recursive CTEs (same pattern as BigQuery/Spark/Trino)
• fabric__get_dbtreplace_directory_pattern — uses charindex/left since T-SQL has no regexp_replace
• fabric__type_string_dpe — returns varchar(8000)
• quote_identifier dispatch macro — wraps reserved-word column names (database, schema) in [brackets] on Fabric
• bool_literal dispatch macro — converts Python booleans to 1/0 in INSERT statements
• fabric__is_not_empty_string — returns 1/0 instead of true/false
• Added fabric to all target.type conditional lists (dbt_project.yml, listagg order clauses, materialization configs)
• Guarded ORDER BY in CTEs with {% if target.type not in ['fabric'] %} (invalid in T-SQL without TOP/OFFSET)

Closes #229
Closes #553

Test plan

• Run dbt-project-evaluator against a Fabric Data Warehouse using dbt-fabric
• Verify all models build successfully (48 table models, 1 seed)
• Verify all tests pass (29 data tests, 78/78 total PASS)
• Confirm no regressions on other adapters (cross-platform changes only use ANSI SQL patterns)

🤖 Generated with Claude Code

[Copilot]

Pull request overview

Adds support for Microsoft Fabric Data Warehouse (fabric adapter). Because Fabric uses T-SQL semantics (BIT booleans, no ordinal GROUP BY in CTEs, no || concat, no false literal, no regexp_replace, ORDER BY not allowed in CTEs without TOP/OFFSET, reserved-word handling for database/schema), the PR rewrites SQL patterns across staging and mart models to be Fabric-compatible while remaining ANSI for other adapters, and introduces several Fabric-specific dispatch macros.

Changes:

• New Fabric-specific macros: fabric__recursive_dag, fabric__get_dbtreplace_directory_pattern, fabric__type_string_dpe, fabric__is_not_empty_string, plus new dispatch macros quote_identifier and bool_literal.
• Cross-adapter SQL rewrites: explicit boolean comparisons (= cast(1/0 as boolean)), dbt.concat() instead of ||, where 1=0 instead of where false, column-name GROUP BY, and quote_identifier('database'/'schema') for reserved words.
• Wiring fabric into dbt_project.yml materialization conditionals, listagg ordering lists, and CTE-level ORDER BY guards.

Reviewed changes

Copilot reviewed 54 out of 54 changed files in this pull request and generated 2 comments.

Show a summary per file

File	Description
supported_adapters.env	Adds fabric to supported adapters list.
dbt_project.yml	Adds fabric to materialization-type conditionals and max_depth_dag defaults.
macros/cross_db_shim/quote_identifier.sql	New dispatch macro to bracket reserved column names on Fabric.
macros/cross_db_shim/bool_literal.sql	New dispatch macro to render Python booleans as 1/0 for Fabric.
macros/cross_db_shim/escape_single_quotes.sql	Consolidated single-quote escapers (moved Spark + added Fabric).
macros/cross_db_shim/spark_shims.sql	Removed; logic moved to escape_single_quotes.sql.
macros/cross_db_shim/type_string.sql	Adds fabric__type_string_dpe returning varchar(8000).
macros/is_not_empty_string.sql	Adds Fabric implementation returning 1/0.
macros/get_directory_pattern.sql	Adds Fabric branch using charindex/left (only handles /).
macros/recursive_dag.sql	Adds loop-based fabric__recursive_dag (no recursive CTEs).
macros/unpack/get_*_values.sql	Wraps Python booleans through bool_literal for Fabric compatibility.
models/marts/core/int_all_graph_resources.sql	Uses quote_identifier for database/schema, concat for prefix, Fabric branch for file_name.
models/marts/core/int_direct_relationships.sql	Rewrites boolean expression as CASE.
models/marts/dag/fct_*.sql	Replaces not <bool> with explicit comparisons, ordinals with column names, guards order by in CTEs for Fabric.
models/marts/dag/fct_duplicate_sources.sql	Uses quote_identifier for database/schema references.
models/marts/dag/fct_direct_join_to_source.sql	Moves order by out of CTE to outer select.
models/marts/dag/fct_model_fanout.sql, fct_source_fanout.sql, fct_multiple_sources_joined.sql	Guards CTE order by for Fabric, adds Fabric to listagg ordered list.
models/marts/documentation/*.sql	Replaces not is_* predicates with explicit boolean comparisons.
models/marts/governance/*.sql	Same boolean-comparison rewrites.
models/marts/performance/*.sql	Same boolean-comparison rewrites.
models/marts/structure/fct_model_directories.sql, fct_source_directories.sql	Replaces `
models/marts/structure/fct_model_naming_conventions.sql, fct_test_directories.sql	Boolean comparison rewrites + Fabric listagg handling.
models/marts/tests/*.sql	Boolean rewrites; rewrites cast(sum(...)>=1 as boolean) as CASE for Fabric.
models/staging/graph/**/*.sql	Replaces true/false literals, uses quote_identifier, where 1=0.

---

💡 Add Copilot custom instructions for smarter, more guided reviews. Learn how to get started.

[b-per]

Thanks @sdebruyn 🙌

I had this one on the backburner for the same reason that you found working on it. This requires a lot of changes 😄 .

I will try to give it a proper look in the next few days.
Feel free to ping me in this PR if I haven't gotten back with feedback before next week.

[b-per]

Hi @sdebruyn !

I just did some small changes to the PR.
Are those fine with you? If so, I can get it merged and do a new release.

[sdebruyn]

Yes, LGTM!