Limitations for SQL Server
Current limitations
Holistics handles most SQL Server syntax automatically, but some features remain unsupported. The table below lists the known limitations, available workarounds, and the status of each limitation.
| Limitation | Example | Workaround | Status |
|---|---|---|---|
| 1. String aliases enclosed in single quotes | SELECT 1 AS 'abc 123' | Enclose the alias in square brackets instead: SELECT 1 AS [abc 123] | ⚙️ Fix in progress |
2. Using function LEN() | SELECT LEN('abc 123') | ⚙️ Fix in progress | |
3. Using seed as an alias (seed is treated as a keyword) | SELECT seed.column FROM table seed | Enclose the alias in square brackets: SELECT seed.column FROM table [seed] | ⚙️ Fix in progress |
| 4. Recursive CTEs | ❌ Not supported | ||
| 5. A query model that references another query model or a table model | SELECT * FROM {{ #my_model }} | ⚙️ Fix in progress | |
| 6. Dynamic Query Models | ⚙️ Fix in progress |