You can now use SELECT..INTO in your SQL code when you want to persist the results of a SELECT statement into a table.
Source: Microsoft Azure News SELECT..INTO comes to Azure SQL Data Warehouse