---
title: >-
  ShopifyQL now available as shopifyqlQuery within the GraphQL Admin API -
  Shopify developer changelog
description: >-
  Shopify’s developer changelog documents all changes to Shopify’s platform.
  Find the latest news and learn about new platform opportunities.
source_url:
  html: >-
    https://shopify.dev/changelog/posts/shopifyqlquery-now-available-in-graphql-admin-api
  md: >-
    https://shopify.dev/changelog/posts/shopifyqlquery-now-available-in-graphql-admin-api.md
metadata:
  effectiveApiVersion: 2025-10
  affectedApi:
    - displayName: Admin GraphQL API
      handle: admin-graphql
  primaryTag:
    displayName: API
    handle: api
  secondaryTag:
    displayName: New
    handle: new
  indicatesActionRequired: false
  createdAt: '2025-08-12T12:12:56-04:00'
  postedAt: '2025-10-01T00:00:00-04:00'
  updatedAt: '2025-10-02T10:33:48-04:00'
  effectiveAt: '2025-10-01T00:00:00-04:00'
---

October 1, 2025

# ShopifyQL now available as `shopifyqlQuery` within the GraphQL Admin API

DateOctober 1, 2025

Version[2025-10](https://shopify.dev/changelog?api_version=2025-10)

FlagsNew

SurfacesAPI

Affected APIs[Admin GraphQL API](https://shopify.dev/changelog?api_type=admin-graphql)

Developers can now leverage ShopifyQL to extract valuable insights from all merchant analytics including sales, customer, and product data via the GraphQL Admin API. This enhancement allows for more sophisticated data analysis and reporting.

For a comprehensive guide on the ShopifyQL language, please visit the [ShopifyQL syntax documentation](https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/shopifyql-editor#shopifyql-syntax).

The `shopifyqlQuery` field is now accessible on the `QueryRoot` of the GraphQL Admin API. To learn more about using this new query field, refer to our detailed [documentation](https://shopify.dev/docs/api/admin-graphql/2025-10/queries/shopifyqlQuery).

For example, here is a query that demonstrates how to retrieve total sales data, grouped by month, starting from the beginning of the current year:

```graphql
{
   shopifyqlQuery(query: "FROM sales SHOW total_sales GROUP BY month SINCE startOfYear(0y) ORDER BY month") {
    tableData {
      columns {
        name
        dataType
        displayName
      }
      rows
    }
    parseErrors
  }
}
```

The response contains table data with column and row values, detailing the total sales per month.

```json
{
  "data": {
    "shopifyqlQuery": {
      "tableData": {
        "columns": [
          {
            "name": "month",
            "dataType": "MONTH_TIMESTAMP",
            "displayName": "Month"
          },
          {
            "name": "total_sales",
            "dataType": "MONEY",
            "displayName": "Total sales"
          }
        ],
        "rows": [
          {
            "month": "2025-01-01",
            "total_sales": "5542.954"
          },
          {
            "month": "2025-02-01",
            "total_sales": "1610.094"
          }
        ]
      },
      "parseErrors": []
    }
  }
}
```

Any parsing errors encountered during execution will be listed under `parseErrors`.