title: How can I use subqueries in sequelize.js?
body: <p>I want to change the subquery below to the sequelize code.
  Could you let me know if there's a way to change to the form below</p>
  
  <pre><code>select 
  product_seq
  , product_type_code
  , (select  DETAIL_KOREAN_NAME from CODE_DETAIL where code_id = 'A0001' and detail_code_id =  product_type_code) as product_type
  from land.PRODUCT;
  </code></pre>
  
  <p>For example</p>
  
  <pre><code>models.Product.findAll({
          attributes: ['newColumn']........
      }).then((data)=&gt;{
          res.json(data)
      })
  </code></pre>