The modern data stack and how we structure and orchestrate our pipelines with cloud databases (BigQuery, Snowflake, Redshift, and more) has advanced and become streamlined with a relatively new tool called Data Build Tools (dbt).
There are numerous features which make easier the treating of analytics as code. See the DataOps Manifesto (https://dataopsmanifesto.org/en/) by adding CI features, automated testing, the ability to edit SQL in VS Code, and orchestrate data modeling.