public class UnitLookupService extends AbstractSqlLookupService implements IUnitLookupService {

  @ConfigProperty(ConfigProperty.SQL)
  @Order(10)
  @ConfigPropertyValue("null")
  @Override
  protected String getConfiguredSqlSelect() {
    return "SELECT u.id"
        + "      , u.name || ' (' || u.equi_quantity || ' g)'"
        + " FROM fdb.units u"
        + " WHERE   1=1 "
        + " <key> AND u.id = :key </key>"
        + " <text> AND UPPER(u.name) LIKE UPPER(:text || '%') </text>"
        + " <all> </all>";
  }
}

SQL with binds:
SELECT    U.ID,
          U.NAME || ' (' || U.EQUI_QUANTITY || ' g)'
AS        "lookup_name"
FROM      FDB.UNITS U
WHERE     1 = 1

public LookupRow[] getDataByAll(LookupCall call) throws ProcessingException {
  return new LookupRow[]{
      new LookupRow(1L, "text by all 1"),
      new LookupRow(2L, "text by all 2"),
      new LookupRow(3L, "text by all 3")
  };
}