- format BigQuery SQL queries better (in my opinion). Support configurations for: maximum line length, standardize casing for SQL keywords and builtin functions (upper or lowercase). BigQuery UI does support formatting but the output doesn't look as "eye-catching" as I want.
- auto converting between standard SQL syntax and pipe syntax in BigQuery. Most queries work but some are not supported (for now - only case I see not supported as query that involves star expression in a group by since it requires the knowledge the underlying column of the table to work - though I haven't seen anyone writing this kind of group by query yet during my work)
- bring all the nested CTE to the outer of the query. this will be helpful such as BigQuery doesn't allow nested CTEs inside a recursive query. (recursive CTE will be handy if you have a CTE that is referenced multiple times - in such case, you can use recursive CTE to materialize that CTE so it is calculated once)
All this is done with the help of ZetaSQL library. I've done the code but have not yet have time to create a simple UI for it yet :)