@Override
protected void execPrepareLookup(LookupCall call) throws ProcessingException {
   call.setRec(getCategorieField().getValue());
}

  @Override
  protected String getConfiguredSqlSelect() {
    return "SELECT id, name FROM Test" +
        " WHERE 1=1" +
        " <key>AND id = :key</key>" +
        " <text>AND UPPER(name) LIKE UPPER(:text) + '%'</text>" +
        " AND categoryID = :rec";
  }

Select col1, col2, col3
From table1
Where col3 IN (value1,value2,...,valueN)

where col3 = :myValues

where col3 = :myValues

where col3 LIKE '%[i]first value of my Array or ArrayList[/i]%'

where col3 LIKE '%DE%'

...
        protected void execPrepareLookup(LookupCall call, ITreeNode parent) throws ProcessingException {
          if (getListField() != null) {
            if (getListField().getTable().getSelectedRowCount() > 0) {
              ArrayList<String> listId = new ArrayList<String>();
              int index = 0;
              for (ITableRow row : getListField().getTable().getSelectedRows()) {
                listId.add(row.getCell(0).toString());
                index++;
              }
              c.setMyList(listId);
              c.setListFilter(true);
            }
            else {
              c.setMyList(new ArrayList<String>());
              c.setListFilter(false);
            }
          }
          else {
            c.setMyList(new ArrayList<String>());
            c.setListFilter(false);
          }
}
...

public class myLookupCall extends LookupCall {

  private ArrayList<String> m_MyList = new ArrayList<String>();
  private boolean m_ListFilter = false;

  public boolean isListFilter() {
    return m_ListFilter;
  }

  public void setListFilter(boolean filter) {
    m_ListFilter = filter;
  }

  public ArrayList<String> getMyList() {
    return m_MyList;
  }

  public void setMyList(ArrayList<String> myList) {
    m_MyList = myList;
  }

}

...
  protected String getConfiguredSqlSelect() {
    return "SELECT ID, TEXT, NULL, NULL, NULL, NULL, NULL, 0, NULL As PARENTID, 1 "
        + " FROM MyTable "
        + " WHERE ColID<>0 And ColID<>3 "
        + "      And (0 = :ListFilter OR ID = :{MyList} ) "

  }
...

!MESSAGE org.eclipse.scout.rt.server.services.common.jdbc.internal.exec.StatementProcessor.dump(StatementProcessor.java:809) 
SQL with binds:
SELECT    ID,
          TEXT,
          NULL,
          NULL,
          NULL,
          NULL,
          NULL,
          0,
          NULL
AS        PARENTID,
          1
FROM      MyTable
WHERE     ColID <> 0
          AND ColID <> 3
          AND (0 = :CountryFilter
          OR
          COUNTRYID = :{CountryIDFilterList})
IN  :CountryFilter => ? [INTEGER 1]
IN  :{CountryIDFilterList} => ? [VARCHAR IT]

    List<Long> list = Arrays.asList(1L, 2L);

    Object[][] result = SQL.select("SELECT COMPANY_NR, " +
        "       SHORT_NAME, " +
        "       NAME, " +
        "       TYPE_UID " +
        " FROM COMPANY " +
        " WHERE COMPANY_NR = :id",
        new NVPair("id", list));

SQL with binds:
SELECT    COMPANY_NR,
          SHORT_NAME,
          NAME,
          TYPE_UID
FROM      COMPANY
WHERE     COMPANY_NR = :id

SQL PLAIN Log:
SELECT    COMPANY_NR,
          SHORT_NAME,
          NAME,
          TYPE_UID
FROM      COMPANY
WHERE     ((COMPANY_NR IN (1, 2)))

SELECT ID,
          TEXT,
          NULL,
          NULL,
          NULL,
          NULL,
          NULL,
          0,
          NULL
AS        PARENTID,
          1
FROM      MyTable
WHERE     ColID <> 0
          AND ColID <> 3
          AND ColText1 IS NOT NULL
          AND (ColText Like '% :P1 %' Or ColText Like '% :P2 %')

SELECT ID,
          TEXT,
          NULL,
          NULL,
          NULL,
          NULL,
          NULL,
          0,
          NULL
AS        PARENTID,
          1
FROM      MyTable
WHERE     ColID <> 0
          AND ColID <> 3