BigQuery SQL Formatter

Format BigQuery queries with dialect-aware keyword handling. Runs entirely in your browser.

Indent

Case

Input

select u.user_id, u.email, count(o.order_id) as total_orders from users u left join orders o on u.user_id = o.user_id where u.status = 'active' group by 1, 2 order by 3 desc;

Formatted OutputWaiting…

Key Differences

•Handles STRUCT and ARRAY literals without mangling.
•Preserves SAFE. function prefixes and wildcard table references.
•Backticked identifiers retained.