YDB does not support WITH operator

[vgvoleg]

We are working on DBT adapter for YDB. It is a widespread approach to use CTE WITH <name> AS (<sql>) during model definitions: example

So the only way to use such models with YDB is to rewrite them using different syntax: example

We are not able to use $<name> = <sql> because SQL from model will be wrapped with CTAS

Are there any plans to support this syntax? Users will not be able to use YDB for DBT projects as a drop-in replacement for other DBs.