Is there a way to do an "IN" or "contains" function in liquid?

Last tested: Jun 17, 2020
 

Yep!

For example, this liquid will turn the background color of a value red if the value contains "Test":

sql: ${TABLE}.field_name;; html: {% if value contains "Test" %} <p style="color: black; background-color: red; font-weight:bold">{{ rendered_value }}</p> {% else %} {{ rendered_value }} {% endif %} ;;