title: Scala anorm running query to postgreSQL with set role command
body: <p>I need to execute query in PostgreSQL using anorm. In order to handle authorization I have to set role along with query. My query is as follows.
  <code>set role myuser; select country from country_list</code>
  This works fine when executed directly in postgress. But when tried via anorm gives me no result found exception <code>PSQLException: No results were returned by the query.</code>
  But this is working fine when set role command is removed.</p>
  <p>Code working fine</p>
  <pre><code>import anorm.SqlParser._
  SQL(&quot;select country from country_list&quot;).as(str(&quot;name&quot;).*)
  </code></pre>
  <p>Code throwing exception</p>
  <pre><code>import anorm.SqlParser._
  SQL(&quot;set role myuser; select country from country_list&quot;).as(str(&quot;name&quot;).*)
  </code></pre>
  <p>Exception</p>
  <pre><code>org.postgresql.util.PSQLException: No results were returned by the query.
          at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:115)
          at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
          at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
          at anorm.Sql.$anonfun$resultSet$2(Anorm.scala:78)
  
  </code></pre>