Help Using Variable Results in Select Statement

Hi @akosinski28! I'd like to echo @pyrrho's welcome. :wave:

I think I understand your question, but I'm going to actually suggest a solution that bypasses the need for SQL variables. One of the cool things about the select menu is that the label and value can be distinct. This means you can implement something like the below:

In this example, I'm populating the select menu with elements from the table but specifically mapping the rating_id and rating_name columns to the "Value" and "Label" fields. This way we obscure the id from the user but can still access it as the value of the "Select" component. I'm pretty sure this should solve your problem!