private ColumnMapping.Column nextColumnInfo() {
    int start = pos;
    nextComma();
    String colInfo = sqlSelect.substring(start, pos++);
    colInfo = colInfo.trim();

    String[] split = colInfo.split(" ");
    if (split.length > 1) {
      ArrayList<String> tmp = new ArrayList<String>(split.length);
      for (int i = 0; i < split.length; i++) {
        if (split[i].trim().length() > 0) {
          tmp.add(split[i].trim());
        }
      }
      split = tmp.toArray(new String[tmp.size()]);
    }

    if (split.length == 1) {
      // default to column the same name as the property
      return new ColumnMapping.Column(indexPos++, split[0], null);
    }
    if (split.length == 2) {
      return new ColumnMapping.Column(indexPos++, split[0], split[1]);
    }
    if (split.length == 3) {
      if (!split[1].equalsIgnoreCase("as")) {
        String msg = "Expecting AS keyword parsing column " + colInfo;
        throw new PersistenceException(msg);
      }
      return new ColumnMapping.Column(indexPos++, split[0], split[2]);
    }

    String msg = "Expecting Max 3 words parsing column " + colInfo + ". Got "
        + Arrays.toString(split);
    throw new PersistenceException(msg);
  }