PivotSQL

Make Reports with SQL

With pivot breakdowns and number formats. Works anywhere SQL does. 100% Automatic

1measures:
2    Total Sales:
3        query: sum(sales)
4        format: currency
5    Total Revenue:
6        query: sum(revenue)
7        format: currency
8    Margin:
9        query: $"Total Revenue" / $"Total Sales"
10        format: percentage
11breakdown:
12    rows:
13        - Product

It's as easy as ABC

Describe report.

Show this measure, and breakdown by that column. That's it.

1table: sales
2columns:
3  region:
4    unique_values: [West, Central, East]
5measures:
6  total_sales:
7    query: sum(sales)
8    format: currency.2
9breakdown:
10  columns:
11    - region

Copy compiled SQL.

Instantly get a SQL query that transform data into your report.

1WITH rawdata AS (
2    SELECT region
3        , CONCAT('$', format_number(sum(sales), 2)) AS total_sales
4    FROM sales
5    GROUP BY region
6)
7SELECT MAX(CASE WHEN region = 'West' THEN total_sales END) AS West_total_sales
8    , MAX(CASE WHEN region = 'Central' THEN total_sales END) AS Central_total_sales
9    , MAX(CASE WHEN region = 'East' THEN total_sales END) AS East_total_sales
10FROM rawdata

Paste and Run SQL

to get pivot table. Works anywhere SQL does.

Supercharges Your Favourite Databases

MySQL

Databricks

Spark SQL

PostgreSQL

SQLite

Built for Your Most Demanding Data Workflows

Pivot Big Data Instantly

Transform billions of rows with lightning-fast pivoting. Interact with data at speeds dashboards can't match.

Streamlined Reporting

Generate clean, repeatable reports from structured pivots. Perfect for daily, weekly, and automated insights. Why post-process with Python when you can nail it with just SQL?

Maintainable SQL at Scale

Break down sprawling SQL into reusable modular pieces. Make your team’s data logic consistent and sustainable.