This is a question for AWS. Community PostgreSQL doesn't have any of these concepts, and this is all proprietary modifications to PostgreSQL by Amazon.Maybe my question can be re-summarised as: do DDL operations on temporary tables necessarily have to be written to the WAL? Is there a way to avoid that?
Yes, and no. The tables those commands update are WAL-logged and that status is all-or-nothing.
David J.