With dbt, you can easily verify the correctness of your SQL queries with built-in tests.
Full article about dbt.