[feature request]: automatically JSON.stringify arrays stored as jsonb columns

[dajocarter]

I'm storing an array of strings in a jsonb column and before I save it to the DB I have to JSON.stringify() the array. However, this isn't necessary when saving an object.

For example, in my model's create method, i have to look for the list and stringify it before creation

class ModelName {
  static async create (model, postgresClient) {
    if (model.someList) model.someList = JSON.stringify(model.someList)
    // I would like to avoid this ^
    const saved = await ModelName.objects.connection(postgresClient)
      .create(snakeCaseKeys(model))

My SQL table looks like

CREATE TABLE model_name (
  ...
  some_list jsonb DEFAULT NULL
  ...
)

In my model I have

ModelName.rawObjects = orm(ModelName, {
  ...
  some_list: { anyOf: [{ type: 'null' }, { items: { type: 'string' } }], default: null},
  ...
})

and in my handler decorator I have

routeName.decorators = [
  validate.body({
    type: 'object',
    required: [],
    properties: {
      ...
      someList: { anyOf: [{ type: 'null' }, { type: 'array' }], default: null },
      ...
    }
  })
]