Can Mixed Analytics query API data with SQL syntax?

No. Mixed Analytics' API Connector retrieves raw API responses and outputs them into Google Sheets cells. There is no SQL layer, no query builder, and no way to write JOINs, aggregations, or CTEs against API data. Query Streams' API Connector normalizes API responses into SQL-queryable DuckDB tables, giving you full SQL power over your API data.

Which APIs does Query Streams support as pre-built connectors?

Query Streams currently offers 6 pre-built API connectors: Stripe (payments, subscriptions, invoices), HubSpot (contacts, deals, companies), Shopify (orders, products, customers), Google Analytics 4 (traffic, events, conversions), Google Search Console (search queries, pages, click-through rates), and ShipStation (shipments, orders, carriers). Each connector normalizes API data into SQL tables and includes 20-50 pre-built queries in the Query Library.

How does the encrypted DuckDB cache work?

Each API connector syncs data from the API into a local DuckDB database on the Network Agent. This cache is encrypted at rest with AES-256-GCM . You configure per-table sync intervals (how often the Agent pulls fresh data from the API) and per-table data retention (how long cached data is kept: 1 day, 7 days, 30 days, 90 days, 1 year, or forever). Your SQL queries run against this local cache at database speed, not against the live API, which eliminates latency and rate limit concerns.

Does Query Streams work with Google Sheets like Mixed Analytics does?

Yes. Query Streams has a native Google Sheets add-on and a native Microsoft Excel add-in. Users select a saved query from their library, adjust any available filters, and click run for live data on-demand. Unlike Mixed Analytics, Query Streams also supports Excel, so teams that use both spreadsheet platforms only need one tool.

Do I need to know SQL to use Query Streams?

No. Each connector ships with 20-50 pre-built queries in the Query Library that you can run directly from Google Sheets or Excel without editing any SQL. Nova AI can also generate SQL from plain English descriptions. Describe what data you need -- "show me Shopify orders by product category for Q1" -- and Nova writes, validates, and executes the query. You can also share queries with team members who run them without seeing the SQL at all.

Does Query Streams support databases in addition to APIs?

Yes. Query Streams connects to 10 SQL databases (SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, MS Access, Oracle, Snowflake, BigQuery, DuckDB) plus 6 API connectors -- all in one platform. Mixed Analytics is API-only with no database connectivity. With Query Streams, you can even JOIN API data with database tables in a single SQL query.

Can I share API queries with team members who do not know SQL?

Yes. Save any query -- whether it runs against a database or an API connector -- and share it with anyone. The recipient opens it in the Excel or Google Sheets add-in, adjusts any available filter values, and clicks run. They get live results without seeing the SQL code, schema, or credentials. Mixed Analytics has no concept of sharing an interactive, runnable query; it only produces static spreadsheet output that requires the original API configuration to refresh.

How does pricing compare between Mixed Analytics and Query Streams?

Query Streams offers a free tier and flat-rate paid plans that include database connectors, API connectors, and unlimited query executions under one subscription. You get 10 database dialects and 6 API connectors at the same price. See Query Streams pricing for current details. Mixed Analytics offers a free tier with limited requests and paid plans for higher volumes and additional features.

Can I use Mixed Analytics and Query Streams together?

Yes. Some teams use Mixed Analytics for ad-hoc calls to niche REST APIs and Query Streams for structured SQL access to Stripe, HubSpot, Shopify, GA4, GSC, ShipStation, and their SQL databases. The two add-ons can coexist in Google Sheets without conflict. Over time, as Query Streams adds more API connectors, you may find less need for the manual approach.