final String javaType = metaData.getColumnClassName(columnIndex);
final int sqlType = metaData.getColumnType(columnIndex);
final String columnName = metaData.getColumnLabel(columnIndex);// select field as f1, 1 as f2, here return
                                                               // f1 and f2
final String dbColumnName = metaData.getColumnName(columnIndex);// select field as f1 from t1, here return
                                                                // "field"?
// TODO use talend db mapping files to do type convert to talend type
final String columnTypeName = metaData.getColumnTypeName(columnIndex).toUpperCase();
final int size = metaData.getPrecision(columnIndex);
final int scale = metaData.getScale(columnIndex);

final boolean ignorePrecision = false;
inal boolean ignoreScale = false;

final boolean isNullable = metaData.isNullable(columnIndex) != ResultSetMetaData.columnNoNulls;
final Schema.Entry.Builder entryBuilder = recordBuilderFactory.newEntryBuilder()
               .withName(columnName)
            // .withRawName(columnName)//no need this as withName will do it
               .withNullable(isNullable)
               .withProp("talend.studio.key", "false")// as metadata from sql query, not table metadata, so no key
                                                      // info or no need
            ;
switch (sqlType) {
case java.sql.Types.SMALLINT:
case java.sql.Types.TINYINT:
case java.sql.Types.INTEGER:
    if (javaType.equals(Integer.class.getName()) || Short.class.getName().equals(javaType)) {
         entryBuilder.withType(INT).withProp("talend.studio.type", "id_Integer");
         withPrecision(entryBuilder, ignorePrecision, size);