import groovy.sql.Sql

query = args[0]
sql = Sql.newInstance("jdbc:mysql://localhost:3306/mysql", "root", "", "com.mysql.jdbc.Driver")
sql.query(query){ rs ->
	while(rs.next()){	
		def meta = rs.metaData
		if(meta.columnCount <=0) return
		for(i in 1..meta.columnCount){
			print "${i}: ${meta.getColumnLabel(i)}".padRight(35)
			print rs.getObject(i)?.toString()
			print "\n"
		}
		println '-' * 70
	}
}

import groovy.sql.Sql

query = args[0]
sql = Sql.newInstance("jdbc:mysql://localhost:3306/mysql", "root", "", "com.mysql.jdbc.Driver")

/*sql.query(query){ rs ->
	rs.next()
	println rs.getObject(1)	
}*/


sql.query(query){ rs ->
	while(rs.next()){	
		def meta = rs.metaData
		if(meta.columnCount <=0) return
		for(i in 1..meta.columnCount){
			print "${i}: ${meta.getColumnLabel(i)}".padRight(35)
			print rs.getObject(i)?.toString()
			print "\n"
		}
		println '-' * 70
	}
}

groovy select with metadata

Groovy