title: How to remove CubeJS default Group By clause from query
body: <p><strong>CubeJS</strong> default applies the <strong>Group By</strong> clause when we run any query in it. </p>
  
  <p>For example below is my JSON query for employee Cube:</p>
  
  <pre><code>{
    "dimensions": [
      "Employee.date",
      "Employee.state",
      "Employee.id"
    ],
    "timeDimensions": [],
    "filters": []
  }
  </code></pre>
  
  <p>When I run above JSON query in CubeJS it will run below SQL:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT
    `employee`.updatedAt `employee__date`,
    `employee`.state `employee__state`,
    `employee`.EmpId `employee__id`
  FROM
    DEMO.Employee AS `employee`
  GROUP BY
    1,
    2,
    3
  ORDER BY
    1 ASC
  LIMIT
    10000
  </code></pre>
  
  <p>For reference below is <strong><em>Employee</em></strong> Cube that I have :</p>
  
  <pre><code>cube(`Employee`, {
    sql: `SELECT * FROM DEMO.Employee `,
    title: `Employee`,
  
    measures: {
      count: {
        type: `count`
      }
    },
    dimensions: {
      id: {
        sql: `EmpId`,
        type: `string`
      },
      date: {
        sql: `updatedAt`,
        type: `time`
      },
      state: {
        sql: `state`,
        type: `string`
      }
    }
  });
  </code></pre>
  
  <p>What will be the JSON query that I need to create if I expect below SQL :</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT
    `employee`.updatedAt `employee__date`,
    `employee`.state `employee__state`,
    `employee`.EmpId `employee__id`
  FROM
    DEMO.Employee AS `employee`
  WHERE
    `employee`.updatedAt ` BETWEEN '2019-01-01' AND '2019-05-01'
  LIMIT
    10000
  </code></pre>
  
  <h3>OR</h3>
  
  <p>Is there any way to remove <strong><em>Group By</em></strong> clause from the SQL query generated by CubeJS itself.</p>