Return JSON from a SQL Query

Do you know, you can return JSON data from a SQL query? It is very useful in writing REST or GraphQL API on the top of a SQL Server Database. Let us say you have two tables as shown below, And an emp table as below, You can query employees with their departments as below,...