I think the fact that it's so simple to add, makes the case to just keep it in userland.

SQL is all about nested subqueries. It's hard to escape without creating views, but who has time to lookup that syntax and get their DBA's permission to run the DDL?!?