nano-queries - Simple and powerful database-agnostic Query Builder for TypeScript (work with SQLite, Postgres, GraphQL, Redis, PGlite, etc)

This might be a good fit for a side project I'm cooking up. I am planning on using DBT but I like how this is more dynamic. How does this compare to DBT? Can it turn CTE into views?

Another feature I am hunting for is something that parses the SQL query and produces a pydantic model.