PowerSQL

PowerSQL is an open source data transformation tool built for data analysts, engineers and scientists.

It utilizes the full power of SQL, so you can focus on improving the data and transforming the data to your needs.

PowerSQL helps you improving the quality of your data and code in the following ways:

• Automatic syntax and type checks based on your code. This helps mistakes from reaching
• Expressive data tests using ASSERT-tests.
• Pure SQL, makes it easy to integrate with existing tooling like formatters and PowerSQL currently supports BigQuery and PostgreSQL as backends.

PowerSQL is fully open source, you can find it on GitHub