Using LIKE operator for parameter in derived table

[miamiali]

It's similar to this thread https://www.googlecloudcommunity.com/gc/Modeling/Using-LIKE-operator-and-wildcards-with-Parameters/t... but the solution in this thread is not applicable to creating a derived_table (unquoted is not available for derived table)

Basically, what I want to do is: 

view: view_1 {
derived_table: {
sql:
SELECT  *
FROM `model_1`
WHERE column_1 LIKE  {% parameter parameter_name %}
;;
}