Run SQL query in script console

Run Select Query.groovy

import com.atlassian.jira.component.ComponentAccessor
import com.onresolve.scriptrunner.db.DatabaseUtil
import groovy.sql.Sql
import org.ofbiz.core.entity.ConnectionFactory
import org.ofbiz.core.entity.DelegatorInterface


def issueManager = ComponentAccessor.issueManager


def output = []
def result = [:]

DatabaseUtil.withSql('local_db') { sql ->
 output = sql.rows("""select cfname from customfield where customfieldtypekey = 'com.atlassian.jira.plugin.system.customfieldtypes:select'""")
}
log.warn "${output.size()}"

log.warn "${output.asList()}"

output.each {
 result = it as Map<String,String>
}

result.each {
 log.warn it
}