T-SQL global temporary tables

Customers migrating from commercial databases like SQL Server to Babelfish for Aurora PostgreSQL encounter a limitation with the lack of support for T-SQL global temporary tables. Babelfish for Aurora PostgreSQL only supports local temporary tables, which do not allow cross-session data access. A workaround involves modifying existing T-SQL code to implement T-SQL global temporary table behavior using permanent tables, but it does not replicate all capabilities, such as automatic drop behavior.