SQL editor

Sourcetable includes a built-in SQL editor that lets you query both spreadsheet data and connected databases using standard SQL syntax. It runs on DuckDB, which means fast, in-browser SQL execution.

Opening the SQL editor

Access the SQL editor from the sidebar or toolbar. You can also ask the AI: “Open the SQL editor.”

Querying spreadsheet data

Your sheet names act as table names, and column headers act as column names:

SELECT category, SUM(revenue) as total_revenue
FROM Sheet1
WHERE date >= '2024-01-01'
GROUP BY category
ORDER BY total_revenue DESC

Cross-sheet queries

Query across multiple sheets in the same workbook:

SELECT o.order_id, o.total, c.name, c.email
FROM Orders o
JOIN Customers c ON o.customer_id = c.id
WHERE o.total > 500
ORDER BY o.total DESC

Querying connected databases

When you have database connectors configured, select the data source from the dropdown at the top of the SQL editor, then write your query. Sourcetable runs the query on the remote database and returns results to your spreadsheet.

-- Querying a connected PostgreSQL database
SELECT product_name, SUM(quantity) as units_sold
FROM production.orders
JOIN production.products USING (product_id)
WHERE order_date >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY product_name
ORDER BY units_sold DESC
LIMIT 20

Supported SQL features

Feature	Supported	Examples
SELECT / FROM / WHERE	Yes	Basic queries with filtering
GROUP BY / HAVING	Yes	Aggregations with conditions
ORDER BY / LIMIT	Yes	Sorting and pagination
JOIN	Yes	INNER, LEFT, RIGHT, FULL, CROSS joins
Subqueries	Yes	Nested SELECT statements
CTEs	Yes	`WITH` clauses for readable queries
Window functions	Yes	`ROW_NUMBER()`, `RANK()`, `LAG()`, `LEAD()`, `SUM() OVER()`
UNION / INTERSECT / EXCEPT	Yes	Combining result sets
CASE expressions	Yes	Conditional logic
Aggregate functions	Yes	`SUM`, `AVG`, `COUNT`, `MIN`, `MAX`, `STDDEV`, `PERCENTILE_CONT`
String functions	Yes	`CONCAT`, `SUBSTRING`, `REPLACE`, `REGEXP_MATCHES`
Date functions	Yes	`DATE_TRUNC`, `DATE_DIFF`, `CURRENT_DATE`
Type casting	Yes	`CAST()`, `::type` syntax

Visual query builder

The query builder lets you construct queries without writing SQL:

Select tables

Choose which sheets or connected tables to query from dropdown menus.

Pick columns

Select which columns to include in the output.

Add conditions

Build WHERE clauses with visual filter controls — select a column, operator (equals, contains, greater than, etc.), and value.

Configure joins

If querying multiple tables, define join conditions with visual dropdown selectors for left table, right table, and join columns.

Apply functions

Add aggregations, Excel-like functions (XL functions), and transformations.

Preview and run

See a live preview of your query results as you build. Click Run to execute.

Data library

Save frequently used queries for reuse:

Write and test your query
Click Save to Library
Name and categorize the query
Access it later from the data library in the sidebar

Saved queries can be shared with team members and reused across workbooks.

AI-powered queries

Instead of writing SQL manually, ask the AI in natural language:

“Show me the top 10 products by revenue this quarter”
“How many new customers signed up each month?”
“What’s the average order value by customer segment?”

The AI generates and runs the SQL query, then returns the results. See SQL generator for more details.

Getting started

Spreadsheet

AI features

Data science

Superagents

Tools

Visualizations

Templates

Connectors

Data

Collaboration

Stock trading

Financial analysis

Opening the SQL editor

Querying spreadsheet data

Cross-sheet queries

Querying connected databases

Supported SQL features

Visual query builder

Data library

AI-powered queries

​Opening the SQL editor

​Querying spreadsheet data

​Cross-sheet queries

​Querying connected databases

​Supported SQL features

​Visual query builder

​Data library

​AI-powered queries

Opening the SQL editor

Querying spreadsheet data

Cross-sheet queries

Querying connected databases

Supported SQL features

Visual query builder

Data library

AI-powered queries