Can Query Streams replace Supermetrics for marketing data?

For Stripe, HubSpot, Shopify, Google Analytics, and Google Search Console data -- yes. Query Streams API connectors cache the data locally and let you query it with full SQL. For niche marketing platforms, Supermetrics has broader connector coverage. Many teams use Query Streams for databases and core APIs alongside Supermetrics for marketing-specific platforms.

How does API connector pricing work?

Query Streams uses flat pricing that includes both database and API connector access. There are no per-source charges. Connect your PostgreSQL database and your Stripe account under the same plan. Supermetrics charges per data source, which means adding each new marketing platform increases your monthly cost.

Can I write custom SQL against API data?

Yes. Query Streams API connectors sync data to a local DuckDB cache on the Agent. Once cached, you can query the data with full SQL -- JOINs, subqueries, window functions, CTEs, everything. Supermetrics offers pre-built metrics and dimensions but doesn't support custom SQL queries.

Does Query Streams work with Google Sheets?

Yes. Query Streams has native add-ins for both Microsoft Excel and Google Sheets. Select a saved query, adjust any filters, and run it to get live data on-demand. You can also share queries with teammates or external partners who run them from their own Google Sheets.

Can I share data pulls with clients who don't have a license?

Yes. Query Streams lets you share saved queries with external partners, clients, or vendors. They open the shared query in the Excel or Google Sheets add-in, choose their own filter values, and run it for live data -- all without seeing your SQL code, database credentials, API keys, or needing a Query Streams subscription of their own.

Will Query Streams overload my API with requests?

No. The Agent caches API data locally in DuckDB and syncs on a configurable schedule -- every 15 minutes, hourly, daily, or on-demand. When users run queries, they hit the local cache rather than calling the API directly. 50 users running the same Stripe report generates zero API calls because the data is already cached.

What if I don't know SQL?

Query Streams includes Nova AI, which generates validated SQL from plain English questions. Type 'Show me our top customers by revenue this quarter' and Nova writes the query against your actual database schema, validates it, and runs it. No SQL knowledge required.