Convert value to a stringified JSON representation

[mekinney]

I'm trying to figure out if there is a way to present a value as a JSON string within queried column. In the example below "recordData" has many structures in our collection. The generated drdl is literally 1000's of lines long just for that one key.

Using this simplified document:

{
       "name" : "Mike",
        "recordData" : {
    		"subject" : {
    			"txtFirstName" : "Harley",
    			"selGender" : "Male"
    		}
        },
        "state":"WA"
}

I’d like to create a drdl entry that would convert the whole object to convert the "recordData" object to a string within one sql column.
Example select would be something like this:

name, recordData, state
Mike, '{"subject":{"txtFirstName":"Harley","selGender":"Male"}}', WA

I have to believe this is possible in drdl, but I can't find it in the documentation. Ideally, below would work (but it doesn't):

- Name: recordData
  MongoType: object
  SqlName: recordData
  SqlType: varchar

I'm not sure where else to ask this and couldn't find the source code for mongsqld to figure out if it's supported.