@Override
    public <R> R scanResultSet(ResultSetScanner<R> resultSetScanner) {
        return execute(ResultProducers.returningResults()).scanResultSet(resultSetScanner);
    }
Executes the query, returning the result obtained from the given {@link ResultProducer}.

@param <R> the type of the result
@param producer the result producer.
@return value returned by the result producer.
core/src/main/java/org/jdbi/v3/core/statement/Query.java