title: How to customize SQL query according to GraphQL request using HotChocolate and Dapper?
body: <p>I'm using HotChocolate as my GraphQL server and Dapper to access the database in my project. Currently With each graphql query requesting &quot;some&quot; fields of an entity, the whole row is queried from database and this is wasting resources especially when querying lists of data. I want to customize the sql query according to the requested fields in the graphql query.
  So, this</p>
  <pre><code>{
    product(id: 3) {
      title,
      price
    }
  }
  </code></pre>
  <p>becomes:</p>
  <pre><code>SELECT title, price FROM products WHERE id = 3;
  </code></pre>
  <p>There is a feature in HotChocolate called projection that I think is related to my problem. But unfortunately the documentation is uncomplete and just shows some examples of using projection with entity framework. Is there a way to implement this feature using Dapper? How?</p>