I recently discovered SQL Resolution Scopes in PyCharm (applicable to all Jetbrains professional edition IDEs). This adds type introspection to your temporary t

I recently discovered SQL Resolution Scopes in PyCharm (applicable to all Jetbrains professional edition IDEs). This adds type introspection to your temporary tables (though you do define them twice). Create an SQL file that defines your temporary tables. Create a "DDL Data Source" under the "Database" tab. Add the SQL file using "+ > DDL Files" to the data source. Under "Settings > Languages & Frameworks > SQL Resolution Scopes", add the DDL data source to your project mapping, specific directories or scripts.