Reusing queries but passing parameters to the query

[charris-pando]

I am looking to reuse queries but to have a variable that is passed to the WHERE clause. An example would be like this:
query 1

SELECT * 
FROM machines
WHERE machines.id=1 <- This would be passed into the query when pulling from Prometheus Database 1

query2

SELECT * 
FROM machines
WHERE machines.id=2 <- This would be passed into the query when pulling from Prometheus Database 2

My use case is I have multiple prometheus databases that I want to point towards the sql exporter but the database doesn't need all the data that is returned without the WHERE clause.

Mainly I am trying to keep this as DRY as possible.

I'm a novice with this so am open to any suggestions towards how to implement this without having to repeat configurations with small differences.