# Limitations for SQL Server

> Learn which Holistics features have limited SQL Server support and which workarounds are available.

## 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](/docs/query-parameters) | || ⚙️ Fix in progress |