Re: So did I misread the article or..?
Having only played with DBT for a little bit last year, the constraint with DBT is it's not general-purpose SQL. You write Python to template SQL transformations, but they can't move the data to another database. It reads and writes and then you can in theory move the data you wrote somewhere else.
But we only used the OSS version; perhaps the newer/paid for versions do more.