Many of the features that Microsoft has announced have been in preview or even GA in Azure SQL Database ... of storing JSON data in the VARCHAR(MAX) field. This datatype will also help simplify ...

In this example, indexes 1 and 2 were used. Let’s assume the Player table in the database was structured as follows: The JPA Query object is smart enough to map fields returned from a native SQL query ...