query.setName(fetchSpecName);
query.setDistinct(fetchSpec.usesDistinct());
query.setFetchingDataRows(fetchSpec.fetchesRawRows());
String qualString = fetchSpec.qualifier().toString();
qualString = qualString.replace(" caseinsensitivelike ", " likeIgnoreCase ");
qualString = qualString.replace(" caseInsensitiveLike ", " likeIgnoreCase ");
qualString = qualString.replace(" AND ", " and ");
qualString = qualString.replace(" OR ", " or ");
if (qualString.contains(" like ") || qualString.contains(" likeIgnoreCase ")) {