The good thing here is that other databases like MySQL, TiDB, SQLite etc also support this. so this. And even recursive CTEs are well supported.

https://modern-sql.com/caniuse/with_(non-recursive,_top_leve...