REST API with 1000 query templates

Look at it this way, how likely are you to change the SQL but not the logic?

  • If the normal case is to change both, then you might as well keep them together.
  • if you think you’ll make a lot of changes to the SQL but without having to change the logic, then storing the SQL external has some appeal.

Hope that makes sense,
Cecil