It’s been around for a while: the with-clause in Oracle SQL. And indeed, I used it in the past. The with clause is very useful to modularize your SQLs, especially in views.