code: public static List<Object> buildSingleColumnResults(Result result,
  			int column, GeoPackageDataType dataType, Integer limit) {
  
  		List<Object> results = new ArrayList<>();
  		try {
  			while (result.moveToNext()) {
  				Object value = result.getValue(column, dataType);
  				results.add(value);
  				if (limit != null && results.size() >= limit) {
  					break;
  				}
  			}
  		} finally {
  			result.close();
  		}
  
  		return results;
  	}
docs: Build single column result rows from the result and the optional limit
  
  @param result
  result
  @param column
  column index
  @param dataType
  GeoPackage data type
  @param limit
  result row limit
  @return single column results
  @since 3.1.0