CTE or recursive functions

Do we have recursive/Common Table Expressions in cockroach DB? If not, what is the replacement?

No, CockroachDB does not yet support common table expressions (recursive or not). This is tracked in this issue. There is no general replacement; you’ll have to examine your queries on a case-by-case basis to rewrite them without CTEs (in the case of recursive CTEs this may require loops or other complex logic in the client application). Feel free to post here for help with particular queries.

Does it now supports Recursive CTE ?

Not yet.
Thanks for your interest in CockroachDB!