gui-dataset-query.json

{
   "type" : "query",
   "database" : 1,
   "query" : {
      "source_table" : 1,
      "filter" : [],
      "aggregation" : ["count"],
      "breakout" : []
   },
   "parameters" : [
      {
         "value" : "2016-07-11~2016-07-16",
         "target" : ["dimension", ["field-id", 1]],
         "type" : "date/range"
      }
   ]
}

sql-dataset-query-dimension.json

{
   "type" : "native",
   "database" : 1,
   "native" : {
      "query" : "select count(*) from ORDERS WHERE {{created_at}};",
      "collection" : "ORDERS"
   },
   "template_tags" : {
      "created_at" : {
         "display_name" : "Created At",
         "dimension" : ["field-id", 1],
         "name" : "created_at",
         "type" : "dimension"
      }
   },
   "parameters" : [
      {
         "type" : "date/range",
         "value" : "2016-07-11~2016-07-16",
         "target" : ["dimension", ["template-tag", "created_at"]]
      }
   ]
}

sql-dataset-query-variable.json

{
   "type" : "native",
   "database" : 1,
   "native" : {
      "query" : "select count(*) from ORDERS WHERE created_at = {{created_at}};",
      "collection" : "ORDERS"
   },
   "template_tags" : {
      "created_at" : {
         "display_name" : "Created At",
         "type" : "date",
         "name" : "created_at"
      }
   },
   "parameters" : [
      {
         "target" : ["variable", ["template-tag", "created_at"]],
         "type" : "date/single",
         "value" : "2016-07-13"
      }
   ]
}