Limitations
Currently SQL Simulator only processes DDL\DML statements. There are several more limitation and the below list is not exhaustive.
These limitations will be addressed in future updates.
Tables without primary key or unique records may not have accurate results
Procedural language statements(TSQL,PLSQL, etc.)
Bind Variables
CTE
Cross Apply
Merge