ShopifyQL sales dataset: Latency, limits, and edge cases when filtering by email?

GraphQL Admin API Troubleshooting
1

I’m using ShopifyQL via the GraphQL Admin API to pull time-bound spend for specific customers:

GraphQL

FROM sales
SHOW orders, total_sales
WHERE customer_email = 'customer@example.com'
GROUP BY customer_name, customer_email
SINCE -30d UNTIL today
ORDER BY total_sales DESC
LIMIT 1

Before scaling this for custom analytics, I need clarity on a few technical behaviors from anyone with production experience:

  1. Data Latency: How quickly do new orders reflect in this dataset? Are we talking seconds, minutes, or hours?

  2. Gross vs. Net: total_sales returns the Gross amount (including shipping/taxes). Is there a clean way to isolate Net product revenue using this dataset?

  3. Refund Attribution: If an order is placed inside the queried time window, but refunded outside of it, does total_sales still decrement properly?

  4. Rate Limits: Since this is an on-the-fly analytical query, are there severe rate-limiting penalties for running it frequently across different emails?

  5. The Gotchas: Has anyone run into undocumented limitations, weird edge cases, or generally had a bad experience relying on this API at scale?

Any insights or war stories are appreciated. Thanks!