Sql parameter list not working

[viswa-optimusprime]

Hi ,
The below query not working . Its not accepting the list . No results returned.

private SqlQuerySpec getQuery(List namesList) {
ArrayList paramList = new ArrayList();
paramList.add(new SqlParameter("@NAMEs", namesList));
SqlQuerySpec querySpec = new SqlQuerySpec(
"SELECT * FROM Test t WHERE t.name in(@NAMEs)",
paramList);
return querySpec;
}