However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

Does 3.23 support derived tables (aka inline views)? If so, plug the SELECT statement that would have generated the temp. table directly into your main query, and Bob's your uncle.

So, when asked the right way, Microsoft Copilot can write basic SQL code for your employees. However, whatever answers are generated by Copilot should always be scrutinized for applicability and ...