Wouldn't a single application of a temp table be sufficient?[0]

0: https://brianchildress.co/reorder-columns-postgres/