For JSON PATH with ROOT Option

SQL Server FOR JSON Clause

SQL Server FOR JSON Clause is used to format query result to JSON format or export data from SQL Server as JSON format. It was introduced in SQL Server 2016 version.