Use case -
Currently, we only have the option to use the "field key" parameter in the field in run macro to substitute the value selected in the field to the SQL macro, but if we want to use a specific value to be substituted to the SQL query we do not have this option as of now.
i.e if we have a checkbox type of field as shown the below screenshot and if the field has three different values.
and if the user wants to extract values "admin" in one variable and "admin1" in other variable so that I can give it as input to SQL. We would like to mention a variable similar to the one mentioned in the below SQL where $username.1 is the first value in the checbox and $username.2 is the second value in the check box