Empty SQL Response

[Harry_Doan]

I think the part using array in SQL query is not straight forward

where contract_name in ( {{contractsInput.values.toString()}} )

We use prepared statement by default so the whole contractsInput.values will be passed in as a string. Here is a guide to do it in Retool

SQL Cheatsheet - best practices for different flavors of SQL syntax

Learn about some best practices for working with SQL! This post is back by popular demand -- we all use SQL in our Retool apps fairly often. Example SQL snippets to use for the various SQL resource types can be super useful to have on hand. Use arrays in queries Every SQL database has a slightly different way of handling arrays. Because SQL resources in Retool are set to convert queries to prepared statements by default this can have more challenging interactions with multiple values inside a s…

e.g. for PostgresQL:

SELECT
  *
FROM
  users
WHERE
  id = ANY({{ [1, 2, 3] }})