Comment by chishaku

I highly recommend dbt (data build tool) for a modular approach to sql; postgres, snowflake, bigquery or redshift.

https://github.com/fishtown-analytics/dbt