There are plans to bring back at least stored procs very soon. But to do them properly and as a plugin type (so if you don't need them they aren't there)