This query, for example, finds all the rows in the Customers table that have a valid JSON object in their LastUpdate column: Select * From Orders.Customers Where (ISJSON(LastUpdate) > 0) Of course, it ...

So let's say you managed to have one or more columns of JSON data in a canonical relational table. Therefore, columns with primitive data and columns filled with JSON data live side by side. Unless ...