Use multiple values from js array into a SQL in Retool

January 13, 2024 • 1 min read

If you’re a Retool user, here the tip to make a SQL query that uses in the WHERE clause one or multiple values that come from a multi-select component:

SELECT
  *
from
  "Table"
WHERE
  category = ANY ()