title: Updating JSON column in Postgres?
body: <p>I've got a JSON column in Postgres, that contains data in the following structure</p>
  
  <pre><code>{
      "listings": [{
              "id": "KTyneMdrAhAEKyC9Aylf",
              "active": true
          },
          {
              "id": "ZcjK9M4tuwhWWdK8WcfX",
              "active": false
          }
      ]
  }
  </code></pre>
  
  <p>I need to do a few things, all of which I am unsure how to do</p>
  
  <ol>
  <li>Add a new object to the listings array</li>
  <li>Remove an object from the listings array based on its id</li>
  <li>Update an object in the listings array based on its id</li>
  </ol>
  
  <p>I am also using Sequelize if there are any built in functions to do this (I can't see anything obvious)</p>