Hi @jeevenugo Please see this doc: SQL Cheatsheet - best practices for different flavors of SQL syntax
Postgres uses = ANY() syntax in Retool
Assuming prepared statements are enabled and cardList is an array, it should work with just t.cardnumber = ANY({{startTrigger.data.cardList}})