It has advantages over plpgsql, such as the ability for the planner/optimizer to do inlining.

All stored procedures that only to "return query ...; return;" are candidates for this change.