GORM with MemSQL json query

Question

MemSQL has the ability to support JSON Query. Is GORM able to perform JSON query, or it is a must to write SQL in my application?

Answer 1

You can set the sqlType in the static mapping to match the MemSQL type 'JSON':

class Entity {
    String info

    static mapping = {
        info sqlType: 'JSON'
    }
}

Then you can push JSON data in doing something like this:

new Entity(info:'{"foo":"bar"}').save()