presto-jdbc/src/main/java/io/prestosql/jdbc/ColumnInfo.java/ColumnInfo/getType
class ColumnInfo:    private static int getType(ClientTypeSignature type)
    {
        switch (type.getRawType()) {
            case "array":
                return Types.ARRAY;
            case "boolean":
                return Types.BOOLEAN;
            case "bigint":
                return Types.BIGINT;
            case "integer":
                return Types.INTEGER;
            case "smallint":
                return Types.SMALLINT;
            case "tinyint":
                return Types.TINYINT;
            case "real":
                return Types.REAL;
            case "double":
                return Types.DOUBLE;
            case "varchar":
                return Types.VARCHAR;
            case "char":
                return Types.CHAR;
            case "varbinary":
                return Types.VARBINARY;
            case "time":
                return Types.TIME;
            case "time with time zone":
                return Types.TIME;
            case "timestamp":
                return Types.TIMESTAMP;
            case "timestamp with time zone":
                return Types.TIMESTAMP;
            case "date":
                return Types.DATE;
            case "decimal":
                return Types.DECIMAL;
            case "unknown":
                return Types.NULL;
            default:
                return Types.JAVA_OBJECT;
        }
    }