Way to create drop down select menu that assigns variables for SQL Query

[InsideJob]

Hi,

I'm currently creating a couple SQL Queries to show times from a DB. As of right now to set variables that are needed in the query I just manually hardcode them. I was wondering if there was a way to set up a drop down menu where I could select what I want those variables to be and have them apply to the the SQL Query.

Also worth noting that one of these variables is a list of certain people so was wondering if there would be a way to have a menu select multiple people and add them to the list?

[Nic Brough _Adaptavist_]

How are you running these SQL functions in Confluence pages?  User macro?  App to do it?