DBT has two mechanisms to implement the blog post. The first is macros which closely resembles m4. The second is "ephemeral" models which are separate SQL files which get compiled into a CTE when referenced in the main model.

Check out their guide[0]

0 - https://docs.getdbt.com/docs/get-started/getting-started-dbt...