Frankly, the dbt product hasn't really evolved much. I've been a bit disappointed with its lack of evolution toward this stuff organically. The "modern data stack" is in kind of in a magic position where they are working at very technical companies but the people using it are not SWEs who can build out the tooling themselves so they are just getting buckets of money without a really big value proposition. My team self hosts a dbt core workflow and it's been almost trivial to build out dbt's paid product ourselves