unable to take advantage of user-defined temp schema emulation in SQL server dialect

[jgholap]

Hello,

I posted this in Atlas repo and got redirected to this repo. Reference: OHDSI/Atlas#2973
We are using Azure Synapse (SQL server dialect) for CDM and have been able to stand up Atlas. It uses temporary tables in the SQL generated for cohorts and other parts of Atlas. We are trying to setup temp schema so that it can store temporary tables in temp schema like its supported for most other data systems (oracle, impala, spark etc.). It looks like we have that solution already for other databases but OHDSI ecosystem just defaults to using traditional temporary tables (that start with # in name) for Microsoft based SQL Server flavors (SQL server, Azure Synapse etc.)
There are also new Microsoft data platforms in Fabric (Synapse Warehouse ) that will likely support existing SQL server dialect but due to change in architecture they may not support temp tables , so i think it would be nice to be able to store temporary tables in user-defined temp schema as it can be implemented in these products.
Having that said, can we consider it as an enhancement to improve the ability of customizations related to temporary tables ?