Teradata has the WITH RECURSIVE statement which is pretty easy to use.