JSON can be stored as SQL Server NVARCHAR(MAX) data.
DBBlobEditor can help you to store JSON as SQL Server NVARCHAR(MAX) data:
Batch import json files into SQL Server TEXT / NTEXT / VARCHAR(MAX) / NVARCHAR(MAX)
Batch export SQL Server TEXT / NTEXT / VARCHAR(MAX) / NVARCHAR(MAX) to JSON files