You can in PostgreSQL and it is very useful: https://www.postgresql.org/docs/current/queries-with.html#QU...