title: raw SQL vs ORM If I already know SQL
body: <p>I am currently using PostgreSQL along with nodejs.
  So far, I have developed using raw SQL with <code>pg</code> driver.
  I'm expecting my service to have quite a lot of records in the near future.(10k+)</p>
  
  <p>I have done some research on SQL vs ORM as it is not a new issue.
  From what I understood,</p>
  
  <p>SQL has better performance,
  ORM enhances code readability, reduces code length and easier to learn than SQL.</p>
  
  <p>This research <a href="http://www.diva-portal.org/smash/get/diva2:1014983/FULLTEXT02" rel="nofollow noreferrer">http://www.diva-portal.org/smash/get/diva2:1014983/FULLTEXT02</a> shows quite drastic performance difference between raw SQL and ORM when row count increases. Because the research has been carried out with <code>Laravel ORM</code>, I am aware that the result can be different with <code>nodejs ORM sequelize</code>.</p>
  
  <p>My code is quite long because I have SQL strings in my functions. If I already know how to write SQL, should I switch to ORM?</p>
  
  <p>Added: 
  If I were to implement ORM, because I have some complex queries joining and aggregating several tables, would it be a bad choice if I use ORM for simple <code>SELECT</code> and <code>INSERT</code> and raw SQL for complex queries?</p>