sqlglot.dialects.fabric

12class Fabric(TSQL):
13    """
14    Microsoft Fabric Data Warehouse dialect that inherits from T-SQL.
15
16    Microsoft Fabric is a cloud-based analytics platform that provides a unified
17    data warehouse experience. While it shares much of T-SQL's syntax, it has
18    specific differences and limitations that this dialect addresses.
19
20    Key differences from T-SQL:
21    - Case-sensitive identifiers (unlike T-SQL which is case-insensitive)
22    - Limited data type support with mappings to supported alternatives
23    - Temporal types (DATETIME2, DATETIMEOFFSET, TIME) limited to 6 digits precision
24    - Certain legacy types (MONEY, SMALLMONEY, etc.) are not supported
25    - Unicode types (NCHAR, NVARCHAR) are mapped to non-unicode equivalents
26
27    References:
28    - Data Types: https://learn.microsoft.com/en-us/fabric/data-warehouse/data-types
29    - T-SQL Surface Area: https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area
30    """
31
32    # Fabric is case-sensitive unlike T-SQL which is case-insensitive
33    NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_SENSITIVE
34
35    class Tokenizer(TSQL.Tokenizer):
36        # Override T-SQL tokenizer to handle TIMESTAMP differently
37        # In T-SQL, TIMESTAMP is a synonym for ROWVERSION, but in Fabric we want it to be a datetime type
38        # Also add UTINYINT keyword mapping since T-SQL doesn't have it
39        KEYWORDS = {
40            **TSQL.Tokenizer.KEYWORDS,
41            "TIMESTAMP": TokenType.TIMESTAMP,
42            "UTINYINT": TokenType.UTINYINT,
43        }
44
45    Parser = FabricParser
46
47    Generator = FabricGenerator

35    class Tokenizer(TSQL.Tokenizer):
36        # Override T-SQL tokenizer to handle TIMESTAMP differently
37        # In T-SQL, TIMESTAMP is a synonym for ROWVERSION, but in Fabric we want it to be a datetime type
38        # Also add UTINYINT keyword mapping since T-SQL doesn't have it
39        KEYWORDS = {
40            **TSQL.Tokenizer.KEYWORDS,
41            "TIMESTAMP": TokenType.TIMESTAMP,
42            "UTINYINT": TokenType.UTINYINT,
43        }