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