What is the method for retrieving a variable within the WHERE clause of BigQuery?

edit

To retrieve a variable within the WHERE clause of BigQuery, you can use the syntax "${variable_name}". For example, if you have defined a variable "age" with a value of 30, you can use it in the WHERE clause like this:

SELECT name, age FROM my_table WHERE age > ${age}

This will substitute the value of the "age" variable in the WHERE clause and return all rows with an age greater than 30.