title: How to use MySQL JSON datatype with Sequelize
body: <p>I'm trying to use MySQL 5.7 with Sequelize, and I want to use the JSON datatype for the <code>attributes</code> field on my <code>users</code> table to keep track of user attributes such as home_phone, mobile_phone, work_phone, address and several other attributes/settings that every user may or may not have.</p>
  
  <p>I've been able to locate the documentation for performing selects here: <a href="http://docs.sequelizejs.com/manual/tutorial/querying.html#json" rel="noreferrer">http://docs.sequelizejs.com/manual/tutorial/querying.html#json</a>.</p>
  
  <p>I'm struggling to find documentation on how I would perform create, update and delete.</p>
  
  <p>I guess I could always just do a raw query, but is there a sequelize way to do this?</p>
  
  <p><strong>Update 1</strong></p>
  
  <p>I'm specifically looking for how to perform a query like this in sequelize:</p>
  
  <pre><code>update Users 
  set user_attributes = JSON_SET(user_attributes, "$.phone", "5554443333") 
  where id=7;
  </code></pre>