Create and use Temporary Tables, Views and Common Table Expressions (CTEs) in SQL to simplify complex queries and improve query performance.

With a large number of temporary table SQL statements like CREATE TEMP TABLE AS SELECT ..., after adopting Citus, if left unmodified, these become local tables. Subsequent operations then run entirely ...