SQL Server 2022 takes that ability a few steps further. Last year, I wrote a column on the introduction of query store hints into Azure SQL Database.

Creating a new table from query results can help you build a database of your clients, employees, expenses and other business details by allowing you to select certain columns from existing tables.