REST API with 1000 query templates

To store the queries in a lookup database is one of the choices I consider. The advantage is that queries could be added and updated without deploying and restarting the API. And this should really simplify maintaining the API.

The disadvantages are that you add an extra (delaying?) layer AND the API cannot be moved to another server in an easy way.

Anyone have any opinion about this or already have done anything using a database for storing queries?