Example query to CosmosDB

example.sql

SELECT DISTINCT CAST(edt.[EditionID] AS varchar) AS editionId
      ,edt.[CoverTitle] AS coverTitle
      ,edt.[ISBN13] AS isbn13
      ,edt.[SubTitle] AS subTitle
      ,edt.[CoverAuthors] AS coverAuthors
      ,edt.[WorkReference] AS workReference
      ,edt.[Binding] AS binding
      ,edt.[Division] AS division
      ,edt.[Format] AS format
      ,edt.[SortTitle] AS sortTitle
      ,edt.[WorkID] AS workId
      ,edt.[Imprint] AS imprint
      ,edt.[Pubdate] AS pubDate
      ,edt.[CreatedDate] AS [CreatedDate]
      ,edt.[UpdatedDate] AS [UpdatedDate]
      , (
        select '[' + STUFF((
        select 
            ',{"id":' + cast(edt2.Id as varchar(max))
            + ',"code":"' + edt2.Code + '"'
            + ',"description":"' + edt2.Full_Description + '"'
            + ',"version":"' + edt2.Version + '"'
            +'}'

        from [somedb].[dbo].[sometable] as edt2
        where edt.EditionId = edt2.EditionID
        for xml path(''), type
    ).value('.', 'varchar(max)'), 1, 1, '') + ']' 
      ) as biccodes
  FROM [somedb].[dbo].[sometable] AS edt
  LEFT JOIN [somedb].[dbo].[anothertable] AS grp ON edt.editionId = grp.editionId
  where edt.editionId = 17311