title: Dynamic sql vs stored procedures - pros and cons?
body: <p>I have read many strong views (both for and against) SPs or DS.</p>
  
  <p>I am writing a query engine in C++ (mySQL backend for now, though I may decide to go with a C++ ORM). I cant decide whether to write a SP, or to dynamically creat the SQL and send the query to the db engine.#</p>
  
  <p>Any tips on how to decide?</p>