db.arrayCollection.insert( { "_id":"123", "a":[ {"id":"one", "d":ISODate("2015-10-06T12:00:00Z")}, {"id":"two", "d":ISODate("2015-10-06T12:01:00Z")} ] } ) Open Table data editor and update array field part e.g “one” to “One” Go to Preview SQL tab,observed that the value of “a” is not enclosed in single quotes. Previous result : The value of “a” was getting enclosed in single quotes,making it a string. Fixed in ADS v16.0.9-2 ------ More Tests ------ db.allDataTypes.insert({colDouble:12345.67,colString:"Umesh Dutonde",colRecord:{comment_by:"umesh",rating:4.5},colArrayRecord:[{profit:123.45,date:new Date()}],colArrayString:["India","USA"],colBinary:BinData(0,"e8MEnzZoFyMmD7WSHdNrFJyEk8M"),ColBoolean:true,colDate:Date(),colNewDate:new Date(),colNewISODate:new ISODate(),colISODate:ISODate(),colNull:null,colTimestamp:new Timestamp(),colMinKey:MinKey,colMaxKey:MaxKey}) CREATE COLLECTION allDataTypes GO INSERT INTO allDataTypes(_id, colDouble, colString, colRecord.comment_by, colRecord.rating, colArrayRecord, colArrayString, colBinary, ColBoolean, colDate, colNewDate, colNewISODate, colISODate, colNull, colTimestamp, colMinKey, colMaxKey) VALUES(OBJECTID('561cc8ce559a55424d00248a'), 12345.67, 'Umesh Dutonde', 'umesh', 4.5, [ { "profit" : 123.45, "date" : ISODate('2015-10-13T09:03:10.217Z') } ], [ 'India', 'USA' ], HEXDATA('7BC3049F36681723260FB5921DD36B149C8493C3'), true, 'Tue Oct 13 2015 14:33:10 GMT+0530 (IST)', ISODATE('2015-10-13T09:03:10.219Z'), ISODATE('2015-10-13T09:03:10.219Z'), ISODATE('2015-10-13T09:03:10.219Z'), NULL, BSONTIMESTAMP('2015-10-13 14:33:10', 1), MINKEY(), MAXKEY()) GO Edit a string cell in Table Data Editor ------ db.array.insert({value1:["Maharashtra","Pune"],value2:[{profit:123.45,date:new Date()}]}) db.test4.insert({double:12345.67,name:"Umesh",date:Date()}) db.test4_1.insert({double:12345.67,name:"Umesh",date:ISODate()})