Below are the features requests we have collected so far:
- ALTER Storage Procedure / Trigger / View / Function is not supported (Workaround: user can drop and recreate it alternatively);
- MSSQL SQL Job support, something similar to PostgreSQL pg_cron or Linux cron job;
- (x) SSMS object explorer is not supported (Workaround: user can "new query window" instead).
- ALTER DATABASE SCOPED CONFIGURATION;
- Global temp table support, like MSSQL temp table (DML looks like "create table ##temp (id int)");
- SQL Server resource governor to limit the CPU / Memory / IO resources database by database or user by user for our SAAS ISV customer;
- DENY permission;
- XML data type operations, like VALUE / QUERY / EXISTS and etc;
- EXECUTE AS USER.