title: Feather.js + Sequelize + postgres 11 : How to patch a jsonb column?
body: <p>I would like to update several row of my db with the same object.
  let say I have a column customText type jsonb which contains an array of object</p>
  <p>here my sequelize model :</p>
  <pre><code>  customText: {
      type: DataTypes.JSONB,
      allowNull: true,
      field: &quot;custom_text&quot;
    }
  </code></pre>
  <p>Now from client I send an object:</p>
  <pre><code>const obj = {}        
  const data = {
            textid: &quot;d9fec1d4-0f7a-2c00-9d36-0c5055d64d04&quot;,
            textLabel: null,
            textValue: null
          };
  
      obj.customText = data
      api.service(&quot;activity&quot;).patch(null, obj).catch(err =&gt; console.log(err));
  </code></pre>
  <p>Like the <a href="https://docs.feathersjs.com/api/databases/common.html#adapter-update-id-data-params" rel="nofollow noreferrer">documentation from feathers.js</a> said if I want to replace multiple record, I send an id equal to null.</p>
  <p>So now here come the problem, if I do that my column customText will contain the new object only but I want an array of object, so I want to push the new data in the array. How can I patch the data?</p>
  <p>My guess is to use a <a href="https://docs.feathersjs.com/api/hooks.html#quick-example" rel="nofollow noreferrer">hook in feathers.js</a>  and a <a href="https://devdocs.io/sequelize/manual/raw-queries" rel="nofollow noreferrer">raw query with sequelize</a>. But I'm not sure how to do that.</p>