Array in where clause IN()

[Steven_W]

Thanks! Using Retool Database so it needs to be postgresql. The Postgresql version below works though.

Postgresql:

SELECT
  *
FROM
  table
WHERE
  product_id IN (
    SELECT
      unnest(string_to_array({{transformer.value.toString()}}, ','))
  );

Good start of the day